R
RFJ
Part 1
I have a series of variable numbers in Columns B, C and D (approx 100). I
want to be able to shade cells in both cols B and C when the value in the
Col C cell is greater than the value in the corresponding Col B cell.
Can it be done? If , help would be appreciated
Part 2
I also wish to do a comparison with Col B and Col D values and would wish to
have similar shading.
(As far as col B is concerned, it would shade if Col C /or/ D was bigger -
rather than both.)
Any help would be appreciated.
Tx in advance.
Rob
I have a series of variable numbers in Columns B, C and D (approx 100). I
want to be able to shade cells in both cols B and C when the value in the
Col C cell is greater than the value in the corresponding Col B cell.
Can it be done? If , help would be appreciated
Part 2
I also wish to do a comparison with Col B and Col D values and would wish to
have similar shading.
(As far as col B is concerned, it would shade if Col C /or/ D was bigger -
rather than both.)
Any help would be appreciated.
Tx in advance.
Rob