View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fruitchunk fruitchunk is offline
external usenet poster
 
Posts: 35
Default Conditional Formatting by formula

I want a special format when the cell in column E is MOD,10.375 and the cell
in column F is MOD,10.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"