Conditional Formatting with If Statement

Hi Merlin,

You can do this a couple ways using conditional formatting as shown below. Also, when using conditional formatting, you're already using an IF (hence the "conditional"), so it's usually not necessary to have an IF within the formula.

1. Using "Cell Value Is"
a. In C.F. window, choose 'Cell Value Is'
b. Then choose 'Greater than or equal to'
c. In the textbox, type: =H26*1.8
d. Set a format, click OK

2. Using "Formula Is"
a. In C.F. window, choose 'Formula Is'
b. In formula textbox, type: =I26>=H26*1.8
c. Set a format, click OK

If nothing happens, go back into conditional formatting and check to see if Excel put quotation marks around your formulas. If so, remove them.