View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default How to change cell background color as part of the If statement?

Try Format Conditional formatting Cell value is Greater than =C1
Format Patterns -select red OK your way out.

Assumes you are formatting G1 and C1 is the allowable cost. When G1 exceeds
C1 you get a RED G1.

HTH
Regards,
Howard

"Jim H" <Jim wrote in message
...
I have a spread sheet that I have set up to use for my home budget. In
doing
this I would much like to visually see when a budgeted item has exceeded
the
allowable cost by having the background color of that cell to change to
the
color red if the cost exceeds the set amount.