Thread: IF Statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default IF Statements

Does anyone know how to use an IF statement to change the color of a cell??

An easy example: =IF(A1<=5,1,0). Can I change the value_if_true or
value_if_false to change the color of the cell?

Could probably read: =IF(A1<=5,1,"cell=green")

Thanks.