In , Dave
spake thusly:

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.

Format Col. A cells conditionally, but instead of using
the default "Cell Value Is" in the conditional formatting
dialogue, use "Formula Is" (pull-down selection). The
CF formula for A1, for example, could be:

=B1=1200

(and format the font as green for the condition.)

You can format the whole of Column A to be a red font,
so you don't have to "waste" a second conditional formula
for <1200.

Btw, no need to post the same thing twice.

-dman-