| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format if cell = blank
Hello,
what is the right formula to use for conditional formating for if the each is blank (no data)? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format if cell = blank
=A2=""
if you want the formatting to go into effect when the cell is blank This works as well =LEN(A2)=0 -- Regards, Peo Sjoblom "Cam" wrote in message ... Hello, what is the right formula to use for conditional formating for if the each is blank (no data)? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format - blank vs. 0 | Excel Discussion (Misc queries) | |||
| conditional format if cell value 0 pattern red value blank nothing | Excel Worksheet Functions | |||
| Conditional format if cell does not display a blank | Excel Worksheet Functions | |||
| Conditional Format A Cell If Row Is Blank | Excel Discussion (Misc queries) | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
Linear Mode
