Re: Fill cells with color based on criteria in two cells
- From: "Chip Pearson" <chip@xxxxxxxxxxxx>
- Date: Mon, 2 Jan 2006 17:24:38 -0600
In Conditional Formatting, change Cell Value Is to Formula Is,
and use a formula like
=AND($C$1=TRUE,$F$1="Yummy")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"AA" <AA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:44DF55BD-A694-450B-90DB-A8808A4810F7@xxxxxxxxxxxxxxxx
> Hi,
>
> I have an excel work*** in which there are 1000 rows. Each
> row has 10
> columns. Based on Criteria (ex. Cell C's value =TRUE and Cell
> F
> value="Yummy") I want to fill the entire row with one color and
> the format
> the cell (ex. E with the bold font and red color). The
> conditional formatting
> doesn't work because of the two criteria. Can anybody please
> help? I would
> love to get a non-macro solution but if there isn't any
> non-macro, I would be
> willing to try the macro stuff.
> Thanks in advance
.
- Prev by Date: Re: Conditional hiding of entire rows
- Next by Date: Re: change font to validation drop lists
- Previous by thread: Re: Conditional hiding of entire rows
- Next by thread: Re: Fill cells with color based on criteria in two cells
- Index(es):
