View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sri
 
Posts: n/a
Default I want to fill the cell color based upon the other cell condition

Hi,
Im trying to fill the cell color based upon the other cell conditions. Is
there anyway i can use the forumalas for this.
For Eg.
(if(a2-b2) 15 & e2=50) then f2= red color, else if (a2-b2) ,15 and
e2=30)then f2=blue else f2=nofill)