Question About Conditional Formatting

  • Thread starter Thread starter J.P.
  • Start date Start date
J

J.P.

Im not sure if I placed this in the right board earlier,
but im reposting it from the Reports & Printing Section.

I need 1 field to be color coded from the conditions of 2
other fields. There is no real criteria for the 2 other
fields, only that they have something in them.

So basicly, I need:

Field 1 = No Color if Field 2 and 3 are blank
Field 1 = Orange if Field 2 has a value and 3 is blank
Field 1 = Yellow if Field 2 and 3 have a value.

Not sure if this is possible, but would like to know.
Thanks for you time and help.
 
Back
Top