| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement - compare to coloured cell
Hi Everyone
I'm not sure how to write an IF statement. If Cell A1 is shaded RED, I want cell B1 to to say OK If A1 is not red, then no message. The IF statement is obviously in cell B1. As far as I can see, conditional formatting will not work, because I want a message in B1, not a format. Any ideas? many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement to compare time cell to a time | Excel Worksheet Functions | |||
| COUNT COLOURED CELL | Excel Discussion (Misc queries) | |||
| Using IF statement compare cell ID with data in another column tru | Excel Worksheet Functions | |||
| If statement to compare for wildcard value in another cell. | Excel Worksheet Functions | |||
| IF formula & COLOURED CELL | New Users to Excel | |||
Threaded Mode
