Conditional Formatting with Not work

**squiggler47** · 05-22-2009, 02:47 AM

I am assuming the moderators are satisfied with the post now? (title seems ok, and I can only see it in 1 forum)

But conditional formatting wont change the value of a cell it will only change font/color etc

=IF(F16=No,No,)

is evaluated as true or false in conditional formatting, it doesnt evaluate to "No",""

you can put =if($f$16="No","No","") in the cells

Or use a macro to detect a change in f16 and change the rest of the cells in the range!

**fmluder93** · 05-28-2009, 07:15 PM

Thanks for that. I have tried putting that it in the cell - but as the document is active - reponses can be amended - which deletes the format in the cell.

Im new to macros. How would i write the macro?

**squiggler47** · 05-28-2009, 10:36 PM

Originally Posted by fmluder93

Thanks for that. I have tried putting that it in the cell - but as the document is active - reponses can be amended - which deletes the format in the cell.

Im new to macros. How would i write the macro?

My reply says you CANT put that in a cell! it doesnt work!