XL 2007 - Conditional Formatting

[ladyck3]

I'm working on a score card form and the highest possible score is 300.

I have the formulas such as...

if CELL=Yes 20 pts
if CELL=No -20 pts
If CELL=N/A 0

Problem is, this will skew the score. If the data does not apply (N/A) and we don't give them the points of 20, then its like it being an error and being a -20. SO... here's what I'd like to know...

The Yes/No/NA drop down is in cell F22, in H22 is the points value from that selection. I need to change my formula to show that if it says N/A to give the 20 points but condition that cell so if F22=N/A then H22 will have the 20 points but the "20" will show white letters so the average bear does not see the points. The cell would appear to be blank/empty.

Again, I must remind you gurus out there, I'm notta guru (but they now have me teaching a class... jokes on them)...I do not know VBA coding so is there a way to do this in conventional "Conditional Formatting"???

HELP I need resolve this badly...

Thanks in advance...


ladyck3
aka: Laurie

 

[ladyck3]

Oh never_MIND... I got this... I figured it out after walking away and coming back.

I was thinking about it too much.

Sorry to pester you..

I used the conditional formatting using a formula

=IF(F22="N/A",10) then I formatted the FONT as White.

Thanks anyway all


ladyck3
aka: Laurie