Conditional Formatting with Multiple Criteria in Form

[PoojaPatel]

Dear Friends,

I have query for how to add Conditional Formatting with Multiple Criteria in Form.

Form One:
Entry 1:
Date: 10/10/2019
Items1: Abcy
Items2: qwer
Items3: kjhn

Entry 2:
Date: 11/10/2019
Items1: nbwe
Items2: dfkjy
Items3: Abcy

Abcy is coming in next day so it will be in red text or highlighted.

I have 15 items in a form.

Can any one help me, which is the expression formula I have to write?

 

[arnelgp]

you need to have a form for the Condition Format to work.
on the form select textboxes (items1 to items3).
on the ribbon->format->conditional formatting

Field Value Is: Equal-> "Abcy"

choose the color/back color of your choice.

 

[theDBguy]

Hi. Welcome to AWF! I'm not sure I get the "multiple criteria" part.