mkuznetsov1
10-15-2023, 05:00 PM
I think this is pretty simple for some experts but I don't know how to do a fill based on multiple values. I am modifying a morning report using a button and want to add some code. I want to fill the row from B:G in green if the cell in the "dept" column contains "ENG" AND the cell in the column Cons. contains "WAL.
Additionally, a little trickier same thing but fill in red if the following are met in row,
"Dept" column value contains "ENG"
"Cons." column value does NOT contain "WAL"
"Waiting" column is equal or greater than 5
and "Status" column value does not contain "OFA", "WOI", or "ABB"
31114
Additionally, a little trickier same thing but fill in red if the following are met in row,
"Dept" column value contains "ENG"
"Cons." column value does NOT contain "WAL"
"Waiting" column is equal or greater than 5
and "Status" column value does not contain "OFA", "WOI", or "ABB"
31114