LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default Conditional Formatting Question.

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Question XFILES Excel Discussion (Misc queries) 4 July 23rd 07 07:45 PM
Conditional Formatting Question Gary Excel Worksheet Functions 6 May 7th 07 11:32 PM
Conditional Formatting question Helen Holubowicz Excel Worksheet Functions 8 January 3rd 07 11:34 AM
Another Conditional Formatting Question 1320_Life Excel Worksheet Functions 4 July 22nd 06 10:05 PM
Conditional Formatting question... Dino Excel Discussion (Misc queries) 5 November 18th 05 11:48 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"