Conditional Formating - question...

[dunmore83]

Hi,

I am trying to apply a conditional format to a cell in excel 2007.

I would like to fill the cell with a chosen colour (yellow), but only apply the fill based on the following formula;

=IF(AND(R10="YES",OR(R21="N/A",R21="NO"),OR(R24="N/A",R24="NO"))

Very much appreciated if you can provide any assistance.

Cheers!

 

[VoG]

What do you mean by "check".

You can copy CFs using the Format Painter.