Color Me Red
A B
Range Average
200.0 46.0
500.0 120.0
3900.0 1733.0
950.0 485.0
3000 3317.0
4.8 4.0
2.0 1.2
136.0 87.1
40.0 17.2
need some way to color column B red, if greater than column A
I tried to conditional format but when I copy down it don't work
There are actually 63 rows and 43 columns.
|