Conditional Formatting by formula

  • Thread starter Thread starter fruitchunk
  • Start date Start date
F

fruitchunk

I want a special format when the cell in column E is MOD,1>0.375 and the cell
in column F is MOD,1>0.006944

I know how to write it in a regular formula, but I don't know how to create
a rule description. How would enter
=IF(MOD(E1,1)>0.375,IF(MOD(F1,1)>0.006944,ALERT,)) in "use a formula to
determine which cells to format"
 
First you select the cell(s) that you want the CF to apply to, with
the active cell in row 1, then you can use the formula:

=AND(MOD(E1,1)>0.375,MOD(F1,1)>0.006944)

and then click on the format button and choose the effect that you
want (eg background colour, foreground colour etc). Excel will
automatically adjust the cell references for selected cells on other
rows.

Hope this helps.

Pete
 
Back
Top