Thread
:
Expand Conditional Formatting to all Rows
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 1,522
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
.
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]