Conditional Formatting on Drop Down List
Closed
Mar
-
27 May 2010 à 14:51
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Mar 2013 à 11:54
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Mar 2013 à 11:54
Related:
- Conditional Formatting on Drop Down List
- Excel drop down list multiple columns - Guide
- Counter strike 1.6 cheats list - Guide
- Excel clear formatting - Guide
- Epic games free games list - Guide
- Excel conditional formatting based on date - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
27 May 2010 à 15:44
27 May 2010 à 15:44
Select the rows on which you want to have this formatting.
Let say you want from row 5 to row 55 and the triggering cell is D
Select rows 5:55
goto conditional formatting
enter the formula
=$D5<>""
choose the color by clicking on format in conditional format
$D is saying that trigger is cell D
and 5 is the first row of the selection
formula is saying color when there is a value in d of a row
Let say you want from row 5 to row 55 and the triggering cell is D
Select rows 5:55
goto conditional formatting
enter the formula
=$D5<>""
choose the color by clicking on format in conditional format
$D is saying that trigger is cell D
and 5 is the first row of the selection
formula is saying color when there is a value in d of a row
you cant you will need a macro for that
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
27 May 2010 à 15:46
27 May 2010 à 15:46
Only if you need more than three conditions or the formula cannot be written on sheet and needs some user defined function
27 May 2010 à 16:33
1) i'm not sure what a trigger cell is
2) the "list" of options that the user can pick in the dropdown is hidden in cells AA6-AA21.
3) Some of those options are "good" and some are "bad.
4) What I'm tyring to accomplish is: if the user picks a "bad" option I want the entire row to turn yellow. If the user chooses a "good" option I want the row to remain without color.
27 May 2010 à 16:42
if there is a data in cell in Column D, then turn that row red or if the value in cell C2 is yellow, then turn column C yellow. By trigger I meant the cell that will cause that event to occur.
Lets say that user will be picking up the values in column F based on the list defined in range AA6-AA21
so now you select the rows on which you want this change of color to occur. Lets say its whole sheet. In this case you select all rows
Now go to conditional formatting
and enter this formula
=OR($F1="bad value1", $F1="bad value2", $F1="bad value 3", "What a day")
and choose color yellow
Now if any cell in F column is "Bad Value1" or "bad value2" or "bad value 3", or "What a day" the whole row will turn yellow.
I Just had four values, but you can have more
Hope it make things better
16 Feb 2012 à 12:23
25 Mar 2012 à 16:52
11 Mar 2013 à 08:27