Avatar of pdvsa
pdvsa
Flag for United States of America asked on

Conditional Formatting

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
Microsoft Access

Avatar of undefined
Last Comment
mbizup

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mbizup

Note:

I used "Issue_Sent" in my post.

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

ASKER
Mbizup, thanks for the response.   Do I need to use control source names?
pdvsa

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

It works!  thank you!!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
mbizup

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...
mbizup

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...