Re: Fill cells with color based on criteria in two cells

You can use multiple cells in your formula in the Format|conditional formatting
dialog.

Select your range (A1:J1000 say).

With A1 the activecell, Format|conditional formatting:
Formula is:
=AND($C1=TRUE,$F1="yummy")

And give it that nice format.

AA wrote:
>
> 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

--

Dave Peterson
.