Conditional Cell Formatting in Excel

Microsoft Microsoft excel 2007 (pc)
August 31, 2010 at 12:15:50
Specs: Windows Vista
I'm trying to create cell formatting when a seperate cell value reaches a specified value it will change to red.

Ex. Applying custom format to cell B2. "If B1 is less than 1 FILL RED"

Ideally I'd like to chain this in to 3 opitons.

I really want to FILL particular rows in a table based on the first cell in that row.

Ex. Row2 has a value of 5 make it one color, Row3 is 3 make another and Row4 is 5 make it the same as 2.

See More: Conditional Cell Formatting in Excel

August 31, 2010 at 12:32:54
Well, your description is a tad confusing, but I'll give it a shot:

I assume you know how to apply Conditional Formatting in 2007. if not, review Response # 4 this thread.

Let's say your 3 row table is in B2:D4.

Select B2:D2 and follow the steps to apply a formatting rule. This is the Formula (rule) to use:

=IF($B$2=5, 1, 0)


=IF($B$2=5, TRUE, FALSE)

Pick a Format.

Follow the same procedure for B3:D3 and B4:D4 using:

=IF($B$3=3, 1, 0) etc.

I hope that helps.

Report •

September 1, 2010 at 06:00:23
Thank you

This works jsut as you discribed.

Report •

September 1, 2010 at 06:13:45
Sometimes I get lucky!

Report •
Related Solutions

Ask Question