#1
|
|||
|
|||
Conditional Formatting a column
I'm trying to conditionally format an entire column: For example
I want column H to turn red when Column I has a value less than Column H. But I want it to match up with the row, so H33 changes with I33, H34 changes with the value of I34. |
#2
|
|||
|
|||
Highlight your range H2:H100
Create a new rule with =I2 < H2 |
#3
|
|||
|
|||
I created the rule, after selection the range, and it still didn't format correctly to turn red.
|
#4
|
|||
|
|||
How exactly did you apply the condition? Did you highlight the range starting with the top of the range to the end? Are the numbers actually numbers? Place the given formula in J2. What do you get if H2 = 5 and I2 = 3? True or False. I get True and therefore H2 gets highlighted.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | grexcelman | Excel | 8 | 01-12-2015 10:27 AM |
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | teza2k06 | Excel | 3 | 01-19-2014 02:34 AM |
Creating multiple conditional rules on one column | secoo140 | Excel | 0 | 10-07-2013 12:13 PM |