Forum Discussion
Solved
Data Validation and Conditional Formatting
Hey,
I've been going around in circles trying to figure this out.
I have a data validation list, is there a way for me to have dropdown options link to conditional formatting.
Example,
"Food Option 1" is the dropdown option anything greater than "100" turns green for Food Option 1
"Drink Option 2" is the dropdown option anything greater than "170" turns yellow only for Drink Option 2
Yes - see the attached demo. I created two conditional formatting rules of type 'Use a formula to determine which cells to format'.
Yes - see the attached demo. I created two conditional formatting rules of type 'Use a formula to determine which cells to format'.
HansVogelaar Amazing!!!! Thank you so much thank function worked a treat!
- Use simple conditional formatting? Are you facing any problem to use conditional formatting. You may need to use IF() function.
