View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shallowz shallowz is offline
external usenet poster
 
Posts: 10
Default Formula for change background according to data

i have excel 2007
i want to set up a rule or a setting or something so that when a cell gets a
set of numbers it will change the color of the cell to green example

in the cell i want to add 5, 15, 25, 30 etc
and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will
chance the cell to green.
is there any way of doing this?