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, ...
Yes - see the attached demo. I created two conditional formatting rules of type 'Use a formula to determine which cells to format'.
Use simple conditional formatting? Are you facing any problem to use conditional formatting. You may need to use IF() function.