Select A1:A300, then in CF use a condition of Formula Is and a formula of

=A1<B1 for red

and
=A1=B1 for green

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Richhall" wrote in message
oups.com...
Hi, I have a simple conditional format, where cell a1 goes red, if it
is less than a value in cell b1. If it is greater than or equal to it
is green. The problem is I have 300 rows to do this on. I obviously
dont want to go down all the rows putting the details in each time. If
i copy and paste the conditional format the "cell value is" within the
conditional format always remains as $b$1 when for row 2 the format in
a2 should say b2, a3 say b3 etc etc. Is there a quick way top do this
please?

Cheers

Rich