Johnnyboy5 used his keyboard to write :
I am trying to gets cells to turn red if the number in the cell is
above 20 but I can get it to work using conditional formating - what
am i doing wrong ? or cant it be done that way ?
Johnny
1. Select the cells you want this feature added to.
2. In the CF dialog:
a. choose 'Cell value is'
b. select 'greater than' from the dropdown
c. enter '20' in the box to the right
d. click the 'Format...' button to set the shading.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc