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?
|