Forum Discussion
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...
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.