Conditional Format based on values in table-CodePudding

Home > Software engineering > Conditional Format based on values in table

Conditional Format based on values in table

Time：09-07

How do I conditionally format each individual cell in B27:AM46 based on the table in A94:B114?

Step 02

Paste this formula for each rule

Rules	Formula
Red	`=IFNA(VLOOKUP(REGEXEXTRACT(B2,"(. ) "),$K$2:$L,2,0),"")=1`
white	`=IFNA(VLOOKUP(REGEXEXTRACT(B2,"(. ) "),$K$2:$L,2,0),"")=2`
red	`=IFNA(VLOOKUP(REGEXEXTRACT(B2,"(. ) "),$K$2:$L,2,0),"")=3`

The lookup table needs to be on the same sheet.