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

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

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

.

KKD, check this out as I think it may assist.

EXCEL 2007 take the following actions:-

1. Go into F 1 Help Facility and type in:-

conditional formatting

2. Hit the Search, "button".

3. There is a topic called:-

Conditionally formatted data: Examples and guidlines

4. Click on the above topic.

5. Opening the above topic there is a hyperlink about three quarters of the
way down the page called:-

Conditional Formatting Samples

6. Click on the above hyperlink.

7. A file will open.

Take a look at the Worksheet called:-

Products3

This is about:-

"Shade an entire row where several criteria must be true"

This seems to be what you want.

I have worked through this example myself and it is, "spot on".

Please hit Yes if my comments have helped.

Thanks.











"KKD" wrote:

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

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

.

I'm actually asking a different question. How do I expand the formatting I
have to apply to each individual row?

I can get one row to work, but short of copying this 2000 times, I don't
know how to make this rule apply to each row.
--
KKD


"trip_to_tokyo" wrote:

KKD, check this out as I think it may assist.

EXCEL 2007 take the following actions:-

1. Go into F 1 Help Facility and type in:-

conditional formatting

2. Hit the Search, "button".

3. There is a topic called:-

Conditionally formatted data: Examples and guidlines

4. Click on the above topic.

5. Opening the above topic there is a hyperlink about three quarters of the
way down the page called:-

Conditional Formatting Samples

6. Click on the above hyperlink.

7. A file will open.

Take a look at the Worksheet called:-

Products3

This is about:-

"Shade an entire row where several criteria must be true"

This seems to be what you want.

I have worked through this example myself and it is, "spot on".

Please hit Yes if my comments have helped.

Thanks.











"KKD" wrote:

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

In NameBox type A1:M2000 and hit Enter.

Then CFFormula =$B1=$H1 Note the $ signs.

Format to a color and hit OK


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 09:20:01 -0700, KKD
wrote:

No I have not, and what would I do with this paint brush? I want to use
conditional formatting.

Apply the Conditional Formatting to the range.


"KKD" wrote:

I'm actually asking a different question. How do I expand the formatting I
have to apply to each individual row?

I can get one row to work, but short of copying this 2000 times, I don't
know how to make this rule apply to each row.
--
KKD


"trip_to_tokyo" wrote:

KKD, check this out as I think it may assist.

EXCEL 2007 take the following actions:-

1. Go into F 1 Help Facility and type in:-

conditional formatting

2. Hit the Search, "button".

3. There is a topic called:-

Conditionally formatted data: Examples and guidlines

4. Click on the above topic.

5. Opening the above topic there is a hyperlink about three quarters of the
way down the page called:-

Conditional Formatting Samples

6. Click on the above hyperlink.

7. A file will open.

Take a look at the Worksheet called:-

Products3

This is about:-

"Shade an entire row where several criteria must be true"

This seems to be what you want.

I have worked through this example myself and it is, "spot on".

Please hit Yes if my comments have helped.

Thanks.











"KKD" wrote:

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