Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
If I have a range of cells A1:M20
Column K has a validation list with 6 Options....Yes, No, W, X, Y, Z The conditional formatting is limited to 3 conditions. Can anyone provide code that would permit the colour of the cells in each row in the range A1 to M20 when the appropriate option is selected from the relevant cell in column K. I.E. I want Row range A1:M1 cells to change to say Yellow when "Yes" selected from the list in K1 ......or say red if "No" ( and other colours for W,X Y,Z) An example of the coding would be appreciated , if it's possible? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of Conditional Formats | Excel Worksheet Functions | |||
list all conditional formats | Excel Worksheet Functions | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
How do I set more than 3 conditional formats in Excel | Excel Discussion (Misc queries) | |||
Conditional Formats in Excel | Excel Worksheet Functions |