Have you tried using the format painter which is probably on your tool bar.
Looks like a paint brush


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KKD" wrote in message
...
I cannot get my conditional formatting rule to apply to my entire data set.
My data are set in rows. I want the entire row to format (color fill) when
two specific cells within that row equal each other. I can get the single
row
to work properly, but I can't see how to expand this formula down to each
row
on my worksheet.

I have read several other posts regarding this issue but am still not able
to get it to work, can someone help me out?
--
KKD