Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
applying rounding formula to entire worksheet | Excel Worksheet Functions | |||
Applying pop up calendar to entire worksheet | Excel Worksheet Functions | |||
Applying conditional formating to make cells change color | Excel Discussion (Misc queries) | |||
Applying formula to an entire column | Excel Discussion (Misc queries) | |||
Applying a formula to an entire column | Excel Discussion (Misc queries) |