Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format - Highlighting the whole row | Excel Worksheet Functions | |||
Conditional Format Question | Excel Discussion (Misc queries) | |||
What does Conditional format change when highlighting? | Excel Discussion (Misc queries) | |||
Conditional Format Question | Excel Discussion (Misc queries) | |||
Conditional format question | Excel Discussion (Misc queries) |