Conditional Formating and data validation

[Flashman101]

Hello,

What is the formula to conditionally format other cells based on the selection from a data validation cell? What I want to do is to fill cells with a colour based on a data validation selection.


Then as the second layer of conditional formatting fill cells based on the "start date" (dd/mm/yy) of the selection. I.e the user makes data validation selection and cells auto populate with a colour based on the selection in data validation and start date.

 

[Joe4]

It does not matter if the value from the cell is hard-coded, the result of a formula, or from data validation, Conditional Formatting runs on whatever value is in the cell at the time (regardless of how that value got there).

 

[Flashman101]

Thanks- that puts a stop to that idea!

 

[Joe4]

Thanks- that puts a stop to that idea!

Why does it put a stop to the idea? What I am telling you is that it will work!
Conditional Formatting will work on values that are hard-coded, updated by formula, or the result of a Data Validation drop-box. It treats them all the same way, and works on them all.