Try a formula like

=A1=$F$8:F8

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AliceNXLand" wrote in message
...
I would like to set up 1 conditional format that will grow as I copy &
paste.
All I've been able to do is copy the same over & over. I have tried to
"paste special - format", but it didn't work. Example: Cell value is:
equal
to, $F$8, then Font is White. I would like to grow the "$F$8" as I copy &
paste. Thanks for ANY help.