View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers Meebers is offline
external usenet poster
 
Posts: 80
Default change background color in cells

Use conditional formatting and use greater than 60, background yellow.
"Joe" wrote in message
...
I would like to change the backgound color of a cell to yellow, based on
the
value of that cell being greater than 60. This should apply to all cells
in a
column. When the spread sheet ages, the values in the cells in that column
increase. Can some please help with this. I am a novice rookie who can
barely
spell VB.