Conditional Formatting with Multiple Criteria in Form (1 Viewer)

PoojaPatel

New member
Local time
Today, 09:07
Joined
Feb 25, 2018
Messages
1
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:07
Joined
May 7, 2009
Messages
19,230
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

I’m here to help
Staff member
Local time
Today, 09:07
Joined
Oct 29, 2018
Messages
21,457
Hi. Welcome to AWF! I'm not sure I get the "multiple criteria" part.
 

Users who are viewing this thread

Top Bottom