Conditional formatting? (1 Viewer)

M

MaleNurse325

Registered User.

Local time

Today, 15:06

Joined

Jan 11, 2016

Messages

67

• Feb 13, 2019

• #1

I am having a complete brain f*rt today with a simple problem.

If the field [ItemDesc] is null then I want the formatting of the field [Reason] to be green. If it is not Null I'd like it to be red.

I am a bear of little brain so be gentle with me :banghead:
I will kick myself when you give me the solution.

 

June7

AWF VIP

Local time

Today, 14:06

Joined

Mar 9, 2014

Messages

5,466

• Feb 13, 2019

• #2

Sounds like need to set the BackColor property to green. Then set a Conditional Formatting rule:

Expression Is: Not [ItemDesc] Is Null

 

isladogs

MVP / VIP

Local time

Today, 23:06

Joined

Jan 14, 2017

Messages

18,209

• Feb 13, 2019

• #3

OK - get your big heavy boots on ....
Below are 2 alternative methods of doing the Green - either will work

 

Attachments

• 
  Capture.PNG

  98.7 KB · Views: 103