I am wanting to highlight DV3 one color if it is greater than 10% of DW3 one color and a different color if it is less than 10% of DW3. What formula do I use? right now it just highlight it if it is greater of less, but I want to be more accurate .
@joesanders Select the entire range you wish to conditionally format, for example DV3:DV100. Create the following rules and choose the colour you want.
=DV3>DW3*0.1
=DV3<=DW3*0.1
More detailed information on conditional formatting in the link below.
.png){kind=link}