ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is conditional formatting only blank, unused cells possible? (https://www.excelbanter.com/excel-worksheet-functions/88882-conditional-formatting-only-blank-unused-cells-possible.html)

Cond. formatting blank cells

Is conditional formatting only blank, unused cells possible?
 


Bob Phillips

Is conditional formatting only blank, unused cells possible?
 
yes, use a formula of =LEN(A1)=0

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Cond. formatting blank cells" <Cond. formatting blank
wrote in message
...





All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com