Cell Colour
 

Can't seem to get any help with this :(

I have two two columns in excel

a b
Jan 200
Feb 456
Mar 544
June 1201

'b' numbers already has a conditional format in place using the when "cell
value is" function. So when cell value is less than 1200 the numbers go red.
when its above 1200 they go green...

What I want next is for the dates in column 'a' to change the same colour as
the 'b' numbers.

Cell Colour
 

use Formula Is
in place of
Value Is

for cell A1 formula is:
=B11200 and pick green, etc.
--
Gary's Student


"Dave" wrote:

Can't seem to get any help with this :(

I have two two columns in excel

a b
Jan 200
Feb 456
Mar 544
June 1201

'b' numbers already has a conditional format in place using the when "cell
value is" function. So when cell value is less than 1200 the numbers go red.
when its above 1200 they go green...

What I want next is for the dates in column 'a' to change the same colour as
the 'b' numbers.

Cell Colour
 

In , Dave
spake thusly:

Can't seem to get any help with this :(

See my follow-up to your identical other posting.

-dman-