Conditional Formatting based on TWO Adjacent Cell Value-CodePudding

Home > Software design > Conditional Formatting based on TWO Adjacent Cell Value

Conditional Formatting based on TWO Adjacent Cell Value

Time：10-28

The goal is to highlight value in Column A5 Green, if the values in both B5 and C5 have the value "Confirmed" then also have the same mythology for A6 - A19

I tried using if statements, but it was not working

CodePudding user response：

Use AND:

=AND(B5="Confirmed",C5="Confirmed")

and apply this rule to range A5:A19.

Page link：https//www.codepudding.com/Softwaredesign/590880.html

Prev:Trying to create a table where the columns are IDs, and the rows contain yes/no based on whether or

Next:Find first Monday from date (and every consecutive Monday) and include the first day of every month

Tags：

excelexcel-formulaconditional-formatting

Links：
CodePudding