Forum Discussion
Solved
Data Validation Conditional Formating
I have a shared spreadsheet where coordinators enter staff codes for particular tasks they would like them to do (it's not a timesheet, just a future planning tool). I have set up a data validation t...
You mean something like this?
Adjust the 'Applies to' ranges to your specific needs.
This is the rule for conditional formatting in the attached sample file.
=(B3=$A$17)*ISNA(MATCH(B3,$H$3:$H$17,0))This is the applies to range for conditional formatting.
=$B$3:$B$14;$D$3:$D$14;$F$3:$F$14In cell A17 i've added Data Validation without a dropdown.
In the screenshot all cells containing "July" in ranges $B$3:$B$14;$D$3:$D$14;$F$3:$F$14 are highlighted in red after "July" was removed from range H3:H17.
This just highlights whatever is in cell A17 as red. If I delete something from the list (eg Wednesday), nothing happens. I'm not sure what the ISNA match stuff does, but I've achieved the same result using cell value = $A$17 conditional formatting. It's still not what I want though. Thanks for trying.