Conditional Format of field based on a field

[marianmalone]

I am trying to get the PBirthday field to highlight if the PFirst IsNotNull
PBirthday is a date field. I can get it to highlight on its own but having trouble getting it to highlight based on the value of the other field. Any ideas? Please? I tried the formula on the bottom but it did not work. No error but no results either whether I put True or False

Marian

 

[pbaldy]

Use Expression Is and :

[PFirst] Is Not Null AND Not IsDate([PBirthday])

 

[marianmalone]

I got it to work with this formula

(False=IsNull([SFirst])) And (True=IsNull([SBirthday]))

But I want to try yours as well. I am really getting into this formula stuff. thanks PBaldy!

Marian

 

[marianmalone]

[PFirst] Is Not Null AND Not IsDate([PBirthday])

It worked Too! yeah! so cool!

 

[pbaldy]

Happy to help Marian! The "False=..." and "True=..." is an unusual approach.