Thread: if calculations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TeddyBearDJ
 
Posts: n/a
Default if calculations

I am trying to figure out a way to make a cell change colors if a certain
condition is met. For example, if cell f4 is 192.27 or above, then the cell
font should change to RED to show it is over the number it should be. If
not, then it can stay whatever color it is.
Can anyone figure out how to make this calculation??