Conditional Formatting

pdvsa
pdvsa used Ask the Experts™
on
Experts,

I have a form in split mode with datasheet on bottom.
I am trying to use conditional formatting to color the column [Issue_CSM] if it does not equal either of the other 2 columns.  
Some cells are null though.

Any ideas?  thank you


ConditionalFormatting
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Nerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Try using this for your CF expression:


NZ([Issue_CSM], #1/1/1900#)<> NZ([Issue_Sent], #1/1/1900#) AND NZ([Issue_CSM],#1/1/1900#) <> NZ([Issue_DnB], #1/1/1900#) 

Open in new window

mbizupNerd
Most Valuable Expert 2012
Top Expert 2013

Commented:
Note:

I used "Issue_Sent" in my post.

Your post has "Issue_Sant" (so you may need to correct my field name)
pdvsaProject finance

Author

Commented:
Mbizup, thanks for the response.   Do I need to use control source names?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

pdvsaProject finance

Author

Commented:
I got it.  It is not the control names...just the field names.  

It works!  thank you!!
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013

Commented:
Good question!

Offhand - For CF, I beleive you need the field names (control sources) versus the textbox names.

(If that doesn't work out, switch to using textbox names...)

I'm going to double check myself to verify...
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013

Commented:
Haha!  I thought so... but couldn't quite remember  (I don't recommend getting old).  I don't use CF much.

Glad you've got it sorted...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial