Changing text color based on data

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

Guest

I have a crosstab query that helps create a vacation schedule, where the
calendar is set up accross the report from 1-31, where the hours an employee
took are listed under the day of the month. My manager asked me today to see
if I can set it so the # hours (which is listed under each day if they take a
day off) can be changed to another color if it hasn't been approved yet. All
the text is black right now.

I set up the date entry to have a checkbox to check if it's been approved,
defaulting to checked (Yes) since most are approved by the time they hit my
DB. Is there a way to change the color to, say, red if it's not yet approved?

Thank you!
Stephanie
 
You would need to "push" the checkbox value to the crosstab. One method
would be to set the Value in the crosstab to a negative if the hours haven't
been approved. You could then use code or conditional formatting to color
the negative numbers different from the positive numbers.
 
Back
Top