Forum Discussion
If cell is blank....
If a cell is blank in any of the cells in column B of a worksheet named "test", how can I fill the blank cells with a word and a different cell color automatically with a formula/macro?
Thanks but I'm looking for a formula or macro that does the work automatically.
Hi,
Under Home Ribbon-> Conditional Formatting -> New Rule -> Format only that cell contain -> Choose 'Blanks' from Drop Down Option.
Click 'Format' & Select the Format as you want.