Conditional Formatting question

[kdemyen]

I am trying to get a column formatted but can't seem to get it to work. Here is what I need: I have a value in column D and a value in column T. What I want is if the value in T2 is greater than D2 then make T2 blue.

This is simple for one cell but I need it for the entire column. Must also keep in mind Column T contains formulas.

Can someone please help?

Thanks,
Kevin

 

[scottylad2]

highlight the column you want to change colour then go to conditional formatting and type in the New Rule dialogue box =T2>B2 then format with whatever colour you want then click ok

 

[kdemyen]

When I try that it does not change the row numbers as you go down the column
T2>B2
T3>B3
T4>B4
and so on....
It just changes the entire column based on the one answer. I need the row numbers to change like with an auto fill. But I already have a pretty long formula in the column I need to change.

I don't think I was clear on that in my first post, sorry about that.

 

[T. Valko]

When I try that it does not change the row numbers as you go down the column
T2>B2
T3>B3
T4>B4
and so on....
It just changes the entire column based on the one answer. I need the row numbers to change like with an auto fill. But I already have a pretty long formula in the column I need to change.

I don't think I was clear on that in my first post, sorry about that.

scottylad2's suggestion should work.

What version of Excel are you using?

 

[mctopher]

What version of Excel are you using?

If you're in 2010 something to watch for is the formula and the "Applies to" portion of the Conditional Formatting setup. When you do a new rule by default it makes your reference formula absolute (e.g. $T$1). If this should change rows for each row down make sure the reference is relative (e.g. T1).

Second, depending on a variety of factors you can introduce problems by dragging the formula down. Instead go to teh "Applies to" portion of the conditional formatting rule and make sure the entire range is selected. Between those two items I find most of my conditional formatting issues are fixed.