View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default How do I change the fill color of a cell using an "IF" function

Use conditional formatting. Select the cell, then Data Conditional
Formatting. Set the condition(s) and corresponding format(s). Then if the
condition is satisfied the format will be applied.

"donschap" wrote:

I'm trying to change the fill color of a cell based on a condition (value)..
FOr example if a value is less than 7, fill the cell color in red