Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
I have conditional formatting on column M based on a dollar value (color
changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
Add the first condition for cell M1 as
=I1="T" and choose the color You can have second and third (and more if you have Excel 2007) as the conditions you already have. You can then paint it over rest of Col M "EricD" wrote: I have conditional formatting on column M based on a dollar value (color changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
Yes, that works. However... I was trying to apply the rule to the entire
column, rather than one cell and then copying. There is already data in the document, and if I want to add additional rows in the future, I don't want to have to copy the formatting further down the columns. I hope that makes sense. "Sheeloo" wrote: Add the first condition for cell M1 as =I1="T" and choose the color You can have second and third (and more if you have Excel 2007) as the conditions you already have. You can then paint it over rest of Col M "EricD" wrote: I have conditional formatting on column M based on a dollar value (color changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
If you don't want to copy the format down the column, select the whole of
the column before you define the conditions in CF. -- David Biddulph "EricD" wrote in message ... Yes, that works. However... I was trying to apply the rule to the entire column, rather than one cell and then copying. There is already data in the document, and if I want to add additional rows in the future, I don't want to have to copy the formatting further down the columns. I hope that makes sense. "Sheeloo" wrote: Add the first condition for cell M1 as =I1="T" and choose the color You can have second and third (and more if you have Excel 2007) as the conditions you already have. You can then paint it over rest of Col M "EricD" wrote: I have conditional formatting on column M based on a dollar value (color changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
You can select the whole column and then apply the conditional formula...
or you can select a range and add the formula referring to the first cell in the range... it will be applied to new rows too if you insert them "EricD" wrote: Yes, that works. However... I was trying to apply the rule to the entire column, rather than one cell and then copying. There is already data in the document, and if I want to add additional rows in the future, I don't want to have to copy the formatting further down the columns. I hope that makes sense. "Sheeloo" wrote: Add the first condition for cell M1 as =I1="T" and choose the color You can have second and third (and more if you have Excel 2007) as the conditions you already have. You can then paint it over rest of Col M "EricD" wrote: I have conditional formatting on column M based on a dollar value (color changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
Select the entire column prior to entering the formula.
Make sure you use a relative reference for the rows. =$l1="T" Gord Dibben MS Excel MVP On Thu, 1 Oct 2009 07:31:02 -0700, EricD wrote: Yes, that works. However... I was trying to apply the rule to the entire column, rather than one cell and then copying. There is already data in the document, and if I want to add additional rows in the future, I don't want to have to copy the formatting further down the columns. I hope that makes sense. "Sheeloo" wrote: Add the first condition for cell M1 as =I1="T" and choose the color You can have second and third (and more if you have Excel 2007) as the conditions you already have. You can then paint it over rest of Col M "EricD" wrote: I have conditional formatting on column M based on a dollar value (color changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
Actually, I figured it out through trial and error before I came back and
read this. I had no idea the answers would come so quickly. Thank you! But yes, the "$" was the key. I had already chosen the column letter, but didn't know how to tell it that if ANY cell in column I had a "T", then it should just change it's corresponding buddy over in column M. "Gord Dibben" wrote: Select the entire column prior to entering the formula. Make sure you use a relative reference for the rows. =$l1="T" Gord Dibben MS Excel MVP On Thu, 1 Oct 2009 07:31:02 -0700, EricD wrote: Yes, that works. However... I was trying to apply the rule to the entire column, rather than one cell and then copying. There is already data in the document, and if I want to add additional rows in the future, I don't want to have to copy the formatting further down the columns. I hope that makes sense. "Sheeloo" wrote: Add the first condition for cell M1 as =I1="T" and choose the color You can have second and third (and more if you have Excel 2007) as the conditions you already have. You can then paint it over rest of Col M "EricD" wrote: I have conditional formatting on column M based on a dollar value (color changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Input Time Delays | Excel Discussion (Misc queries) | |||
Conditional Formatting to differentiate between Input and Calcs | Setting up and Configuration of Excel | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional formatting w/ color as input vs output | Excel Worksheet Functions | |||
Formatting to show 0 as first number in a cell when input | Excel Worksheet Functions |