conditional format based on two table column values

Question

The 1st picture below shows something close to what I want to do; apply a red format IF the following two conditions are true:

The [Symbol] column value = "CASH" (column address $B5:$B204)
The date of the [SP Fill Column] is less than Today (column address $CH5:$CH204)

I am trying to do this with two rules applied to the entire CH column as shown below, without success. It seems like I should be apply to just apply the rule to the 3 cells relative to the CASH symbols, but sorting and filtering changes the values.

What is a good way to do this?

yeah, perfect! want to make this an answer so I can close out the question? — Berryl
– Berryl, Commented Jan 17, 2018 at 18:58

Scott Craner · Accepted Answer · 2018-01-17 19:03:09Z

1

Use AND():

=AND($B5="CASH",$CH5<TODAY())

answered Jan 17, 2018 at 19:03

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

conditional format based on two table column values

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related