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 worksheet 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