LutonBarry
02-20-2017, 07:56 AM
Folks,
Not sure if this is possible at all. On the spreadsheet attached I have a data validation list named 'Status" that refers to the items in Cells B19:B29, these cells are all individually formatted.
I have Data Validation applied to the cells in rows 3 to 15 and what I want to happen is when for example "WFH" is selected from the Data validation list then the formatting applied in cell B24 is applied and if "Training" then the format in cell B23 etc.
I've looked around but I've not found anything conclusive.
I'm using Excel 2013.
Thanks in advance.
Regs Barry
Not sure if this is possible at all. On the spreadsheet attached I have a data validation list named 'Status" that refers to the items in Cells B19:B29, these cells are all individually formatted.
I have Data Validation applied to the cells in rows 3 to 15 and what I want to happen is when for example "WFH" is selected from the Data validation list then the formatting applied in cell B24 is applied and if "Training" then the format in cell B23 etc.
I've looked around but I've not found anything conclusive.
I'm using Excel 2013.
Thanks in advance.
Regs Barry