RANGE FILL BASED ON CELL VALUES

[mkuznetsov1]

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

[June7]

Do you know how to use conditional formatting?

Select the 6 columns and create 2 rules:


=AND($C2="ENG",$D2="WAL")

=AND($C2="ENG",$G2>=5,NOT(ISNUMBER(SEARCH(IF(ISBLANK($H2),"XXX",$H2),"OFA,WOI,ABB"))))

[mkuznetsov1]

I do, ill try to work on it with that. I am just new to excel and getting back into it after some years. Also can be overwhelming when you learn its capabilities...sometimes forget the basics.