Excel 2007 : Conditional Format based on value in a column

**kearniesue** · 07-29-2011, 02:33 PM

Hello,

I am working with the attached example and would like to make all cells highlighted if row A is = to 2 or another number.

I have highlighted all cells and in the formula in conditional format I entered: if($A3=2), but it isn't working. Any idea what I'm doing wrong?

Thanks,

Karen

**ConneXionLost** · 07-29-2011, 02:41 PM

Hi,

Try this:

Cheers,

**kearniesue** · 07-29-2011, 02:48 PM

I tried that, but I think the = threw me off. Thanks!

**imnxcguy** · 08-03-2011, 12:52 PM

Thansk, Kearniesue,

It's great to have an Excel question, go right to this forum, type in a simple search for conditional format and find your answer within seconds. These kinds of little computer victories are rare, but highly appreciated.

Mark