Conditional formatting for cell based on value of adjacent cell

[brendanatm]

Hi all!

Here's what I'm trying to do. I have two columns A & B. A is the balance and B is the Total Load Required.

If the value in any cell is column B is less than what's in the adjacent value in column A, then I want the cell in column B to go red or whatever color. In the example below, I would want this conditionally formatting to make cells B3 and B5 red sincce those values are less than what's in cells A3 and A5. Make sense? How do I do it? Any help would be AWESOME! Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
Select B2 downwards & in CF new rule, use a formula & use

=B2<A2

and select the format you want.

 

[brendanatm]

Thank you, but that actually did the opposite of what I wanted and it somehow highlighted the B4 cell which is equal to the A4 cell. Any other ideas? Also, which type of rule should I choose? Here are my options...(second screenshot)

 

[Fluff]

You have selected the entire column rather than B2 down. Therefore the formula should be B1 & A1 as it must match the 1st row in the applies to range.