I need to apply conditional formatting [Closed]

Cam - Mar 18, 2011 at 12:13 PM - Latest reply: rizvisa1 4482 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen
- Mar 18, 2011 at 12:21 PM
Hello,
Example: if the value in cell B3 is between 120% and 129% value of cell F3, then highlight yellow. If the value is greater than 129% highlight red with white font. Can anyone help with this formula?
Thanks,
Cam


See more 

1 reply

rizvisa1 4482 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 18, 2011 at 12:21 PM
0
Helpful
You need two conditional format statments

AND(B3 > =F3 *1.2, B3<=f3*1.29)

B3>f3*1.29