View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Expand Conditional Formatting to all Rows

When all else fails, RTFI
Look in the help index for format painter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KKD" wrote in message
...
No I have not, and what would I do with this paint brush? I want to use
conditional formatting.
--
KKD


"Don Guillett" wrote:

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


.