View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default conditional formating

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