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.

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)

or

=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.

Thank you This works jsut as you discribed.

Sometimes I get lucky!

Ask Your Question

Weekly Poll