Conditional Format and Highlighting question

C

clipski

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting to Another Cell 0
Excel does not accept text format! 0
How do I convert shading to highlighting for specific colors 8
Conditional Formatting help (2003) 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Mail Merge Help 1
Conditional formatting dates 3
error in highlighting duplicate values in excel 1

Top