Adding fill to cells only when value is "No" in another cell

N

Noel

I would like to apply a conditional format to a selection of cells that will
change the fill to gray when the value in another cell = "No". So, let's say
"No" was input into cell A1, if so then cells B1 through E1 would
automatically fill with gray. If the value in A1 is blank or "Yes" or
anything else, then no formatting would occur in those cells because data
would need to be input in them. Is it possible to do this?
 
F

Fred Smith

In B1, create a conditional format of:
=$A$1="No"
and set the fill to gray.

Now copy the format of B1 down to E1 (right-drag the fill handle and choose
Fill Formatting Only).

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top