I had previously set up my worksheet as follows:

Column A

If Cell Value is greater than 0
Then Format that cell to be bold with pink background.

Worked fine.

I later decided that when the Cell Value in Column A was greater than 0 I
wanted B, C, D, E, F, and G of the same row to also format to be bold with
pink background.

I selected A10 - G10 and did a Conditional Formatting.

Formula Is =$A$10<""
Then Format cells A, B, C, D, E, F, and G of that row to be bold with pink
background.

That worked exactly how I wanted it to... For that row... A little stuck on
how I can apply this to EVERY row. I'm talking A10 through A(infinite). Not
like I could actually do each one by hand...

I have the strangest feeling is is some stupid little detail I am missing.

Thanks for your help!
-Ryan

Have you tried to copy and paste special|Formats?

"Ryan Hess" wrote in message
...
I had previously set up my worksheet as follows:

Column A

If Cell Value is greater than 0
Then Format that cell to be bold with pink background.

Worked fine.

I later decided that when the Cell Value in Column A was greater than 0 I
wanted B, C, D, E, F, and G of the same row to also format to be bold with
pink background.

I selected A10 - G10 and did a Conditional Formatting.

Formula Is =$A$10<""
Then Format cells A, B, C, D, E, F, and G of that row to be bold with pink
background.

That worked exactly how I wanted it to... For that row... A little stuck
on
how I can apply this to EVERY row. I'm talking A10 through A(infinite).
Not
like I could actually do each one by hand...

I have the strangest feeling is is some stupid little detail I am missing.

Thanks for your help!
-Ryan

AAHHRRRGGGG!!!

It was a stupid little detail. Not sure why I put the '$' in front of the
10... Got rid of it and all is well.

Ha-Ha
Sorry.

-Ryan

Select the entire column, or from your starting rows hold shift, tap end and
tab down to select all the way down, then go to conditional formatting.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Ryan Hess" wrote:

I had previously set up my worksheet as follows:

Column A

If Cell Value is greater than 0
Then Format that cell to be bold with pink background.

Worked fine.

I later decided that when the Cell Value in Column A was greater than 0 I
wanted B, C, D, E, F, and G of the same row to also format to be bold with
pink background.

I selected A10 - G10 and did a Conditional Formatting.

Formula Is =$A$10<""
Then Format cells A, B, C, D, E, F, and G of that row to be bold with pink
background.

That worked exactly how I wanted it to... For that row... A little stuck on
how I can apply this to EVERY row. I'm talking A10 through A(infinite). Not
like I could actually do each one by hand...

I have the strangest feeling is is some stupid little detail I am missing.

Thanks for your help!
-Ryan