ExcelBanter - Conditional format if cell = blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional format if cell = blank (https://www.excelbanter.com/excel-worksheet-functions/198788-conditional-format-if-cell-%3D-blank.html)

Cam

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

Peo Sjoblom[_2_]

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

All times are GMT +1. The time now is 02:41 PM.