conditional formating
 

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

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

conditional formating
 

On Jan 29, 8:33*pm, GS wrote:
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 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

conditional formating
 

On Jan 29, 8:33*pm, GS wrote:
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 athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

sorry - sorted it forgot the = bit.

thanks