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]

Use the Use a Formula... option with the formula

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

 

[AlphaFrog]

Try this as the CF formula

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

 

[dunmore83]

Thanks for the replies.

I have not used CF formulas often.

Which option do I choose to apply this formula in the CF area so that the end result is the cell being filled with yellow if true, or white if false??

Thanks

 

[VoG]

It is the bottom option: Use a formula to decide which cells to format.

 

[dunmore83]

Ok i found the location. Do I need to put = infront of the forumla??

Also do i simply go into Format near preview & select my fill colour as yellow? Then if the formula is correct the cell will be yellow & if incorrect it will be white??

Thanks for help!

 

[VoG]

Yes, sorry in the formula box enter

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

then click the Format button, on the Fill tab click on yellow then OK your way out.

 

[dunmore83]

When I enter the formula below;

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

.... i get the following message;

"your formula is missing a parenthesis --) or (Check the formula, and then add the parenthesis in the appropriate place."

Do you know why this is??

Cheers.

 

[VoG]

Yes, because I stupidly omitted it

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

 

[dunmore83]

Thanks. Is there a way to check the CF formula??

It would be handy so I could then copy it to other cells.

Cheers