conditional formatting

V

vgupta

Can you please tell me how to do conditonal formatting
example
NUMBER IN A CELL(B2) is 20
show in cell (b6)
Criteria - 1 is less than in cell(b3) - shown in red
&if greater than In cell (b4) - shown in blue
& if greater than cell(b5) - shown in green
How can I then do the above for a other rows(ie. copy this
conditional format)

Appreciate your help
Please ASAP

VGupta
 
Top