T
tg7
I need some help with formatting a field in a report based on a cross-tab
query. I am not very good at code so bear with me. I am currently using the
conditional formatting, but have one additional criteria. The field I need
to format in the report shows audit results. I need one color (default) for
blank/audit not due yet, then the conditional formatting changes to green if
the results are 95% or greater, yellow for 94%-90%, and red for below 90%. I
need one more color to represent that the results are not required for the
particular facility. I want to base this on another field being populated,
the audit received field. If the audit received field has a date, but the
results field is blank, I want the report to show dark blue in the results
field.
Is this possible?
query. I am not very good at code so bear with me. I am currently using the
conditional formatting, but have one additional criteria. The field I need
to format in the report shows audit results. I need one color (default) for
blank/audit not due yet, then the conditional formatting changes to green if
the results are 95% or greater, yellow for 94%-90%, and red for below 90%. I
need one more color to represent that the results are not required for the
particular facility. I want to base this on another field being populated,
the audit received field. If the audit received field has a date, but the
results field is blank, I want the report to show dark blue in the results
field.
Is this possible?