Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,388
Default Applying color to an entire row

I am trying to get all of the text in a row to change to the color that I
have set in a single cell using conditional formatting. If the conditons are
true for that single cell and it changes to the chosen color, how can I make
the enitre row change to match the two conditions I have set for that single
cell?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default Applying color to an entire row

Something like setting Conditional Format to:
Formula Is: =AND($B210,$B2<100)
while selecting the entire row by clicking the row header number
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Dave" wrote in message
...
I am trying to get all of the text in a row to change to the color that I
have set in a single cell using conditional formatting. If the conditons
are
true for that single cell and it changes to the chosen color, how can I
make
the enitre row change to match the two conditions I have set for that
single
cell?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Applying color to an entire row

hi
what are the conditions that you have set so far?

Regards
FSt1

"Dave" wrote:

I am trying to get all of the text in a row to change to the color that I
have set in a single cell using conditional formatting. If the conditons are
true for that single cell and it changes to the chosen color, how can I make
the enitre row change to match the two conditions I have set for that single
cell?

Reply
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
applying rounding formula to entire worksheet mateo Excel Worksheet Functions 17 May 15th 23 07:44 PM
Applying pop up calendar to entire worksheet Klee Excel Worksheet Functions 3 July 30th 07 07:28 AM
Applying conditional formating to make cells change color [email protected] Excel Discussion (Misc queries) 1 March 6th 07 10:51 PM
Applying formula to an entire column Stephan Excel Discussion (Misc queries) 1 October 2nd 06 03:36 AM
Applying a formula to an entire column Audrey Excel Discussion (Misc queries) 3 April 20th 06 07:26 PM


All times are GMT +1. The time now is 06:08 PM.

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

About Us

"It's about Microsoft Excel"