applying conditional formatting

S

shanemarkley

I'm trying to apply a conditional format to my table that will change
the background color of ever cell that is blank to a light gray. The
farmat I apply is Cell Value IS equal to and then I leave the third box
blank and set the format background color to gray. Is there something
wrong with the formula I created or is there something else I need to
do to apply the conditional format to the table? :confused:
 
M

Max

Try this ..

Select the target range, say A1:E10

Click Format > Conditional Formatting
Under Condition 1, make the settings:
Formula is | =A1=""
Click Format > Patterns tab > Light gray > OK
Click OK
 
Top