Need help w/conditional formatting date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field where I have a conditional formatting to be red and
bolded if another date field is overdue. Now I need to unbold and undo the
color red if another date field is entered. Can I still do this in
Conditional Formatting. I do not write code. I rather do it in Conditional
Formatting. How do I write this? Do I use Expression Is , Value or Focus?
Thanks in advance for any help you can give me.
 
You need to use multiple conditional formats. Select the field, choose
Format, Conditional Formatting. You should already have the RED/BOLD format
condition in place. Select ADD and use the Field Value Is...to use a
comparison of this field to antoher field, use the buttons to reformat your
data.
 
Back
Top