I am attempting to get excel to highlight a row based on the result of a specific column.
Excel Issue - Conditional Formating.JPG
D Column Formula: =C2/$C$13
F Column Formula: =E3/$E$13
G Column Formula: =IF(D2,(F2-D2)/D2,0)
H Column Formula: =IF(B2,((E2*24)-B2)/B2,0)
Columns B, C & E are manual entry fields.
Formatting Rule for Column G & H: Green Up Arrow when value is > = 0.01; Yellow Dash when value is = 0; Red Down Arrow when value is < 0
How do I set up the conditional formating so that the row will be highlited a color when the total in Column H is > than the total in Column B?
Thank you in advance for your help!!!
Bookmarks