Prev: Counting Results of Formulas
Next: Finding most recent date for each customer - XL 2007
From: Noel on 29 Apr 2010 19:48
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?
From: Fred Smith on 29 Apr 2010 20:08
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

"Noel" <Noel(a)discussions.microsoft.com> wrote in message
news:8961564D-B259-45B0-AD07-E0AC6A4A98C4(a)microsoft.com...
>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?

 | 
Pages: 1
Prev: Counting Results of Formulas
Next: Finding most recent date for each customer - XL 2007