| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formating based on blank cell
Sorry, I had it the other way around earlier
Same steps, but use this as the CF formula: =NOT(ISNUMBER($F1)) You could pre-fill the entire sheet with a fill color of your choice as the "untriggered" background -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Kimti" wrote: Thanks for your help, it did not work the way I would like to see. I want to see only one row to be conditional formated based on the date not being in one cell for that row. whole idea is that that cell is showing if the task is complete. If date is not their I want to see different color so it stands out from the sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I refer to a blank cell when using conditional formating? | Excel Discussion (Misc queries) | |||
| Conditional formating -identify blank cell | Excel Worksheet Functions | |||
| Set conditional formating for cell based on value in different cel | Excel Discussion (Misc queries) | |||
| Conditional Formating based on another cell | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
