Conditional Format and Highlighting question
 

Hello,

I got help in a previous request on highlighting text from a conditional
format issue and it works great. I do have one additional question however.

I am doing a conditional If statement

=IF(F9=G9,"PASS","FAIL") and highlighting PASS green if equal and FAIL
red if it not equal, however, I have some column cells that have no data at
all and in those conditions, I would like the text "No DATA" to be shown.
How is this done? Basically from the equation above, if either or both F9
and G9
have no data in the cell, I want the text in another column to say "No Data"

Thank you,

Conditional Format and Highlighting question
 

Try:

=IF(AND(F9="",G9=""),"No Data",IF(F9=G9,"PASS","FAIL"))


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111058