Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am comparing two sets of numbers and would like to format the cell if the
difference is within a certain range - as follows (where ABC and HIJ are the columns, Length Width Height are in Row 1): A B C Length Width Height 12.9 11.0 4.0 7.3 7.0 4.8 23.5 3.5 3.5 12.8 11.0 6.0 H I J Length Width Height 12.90 10.92 5.58 7.60 7.00 5.10 23.30 3.60 3.60 12.20 9.90 4.60 When the difference between H2 and A2 is .5 (positive or negative) I would like to shade the cell in H, I, or J. In the above example, J2 would be shaded, H2 and I2 would not and so on. I'm not sure how to capture the variance. Can this be acheived using conditional formatting? Thanks in Advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - 2 columns | Excel Worksheet Functions | |||
Conditional Formatting Non-Adjacent Columns | Excel Worksheet Functions | |||
conditional formatting- same value, different columns | Excel Discussion (Misc queries) | |||
conditional formatting for key-value columns | New Users to Excel | |||
Conditional Formatting 4 Columns | Excel Discussion (Misc queries) |