conditional formating

[Johnnyboy5]

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

 

[GS]

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.

 

[Johnnyboy5]

Johnnyboy5 used his keyboard to write :



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 athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi

still wont work. Its a column with a formula in each cell which uses
today's date minus a previous date and gives an answer in days -

Johhny

 

[Johnnyboy5]

Johnnyboy5 used his keyboard to write :



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 athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

sorry - sorted it forgot the = bit.

thanks