| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format A Cell If Row Is Blank
You're welcome, have a good day.
Railrd wrote: Thanks to the both of you didn't think about using COUNTA. That was a typo I had meant cell B2. Thanks again "Bob I" wrote: If you really want A2 to be red font if the rest of row 2 is blank then use "Formula is" =COUNTA($B$2:$IV$2)=0 and set red font. That's all you need. The "Auto Black" is the default, and you don't need to mess with it. Railrd wrote: I would like to have cell A2 with a red font if the rest of the row is blank. If anything is entered in any other cell I want it to return to the black(auto) font setting. I have tried several formulas and can onlt get it to work if cell A3 gets data entered. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting: format when range of cells are blank | Excel Discussion (Misc queries) | |||
| Conditional format -blank | Excel Worksheet Functions | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
