conditional formating

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
J

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
 
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
Click to expand...

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 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
Click to expand...

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 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
Click to expand...

sorry - sorted it forgot the = bit.

thanks
 
Back
Top