Conditional Formatting

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

Guest

I have a report that looks something like this:
Class Ques 1 Ques 2 Ques 3
Class 1 50 75 23
Class 2 23 99 52

Is there a way to use Conditional Formatting to format just the highest
value per record? So, in Class 1, format just '75' and in Class 2, format
just '99'?

Thanks -
 
You can use conditional formatting for this. Set the conditional formatting
"Expression Is" to something (for Ques 1) like:
[Ques 1] > [Ques 2] AND [Ques 1] > [Ques 3]
 
Excellent - works great! Thank you so much!


Duane Hookom said:
You can use conditional formatting for this. Set the conditional formatting
"Expression Is" to something (for Ques 1) like:
[Ques 1] > [Ques 2] AND [Ques 1] > [Ques 3]

--
Duane Hookom
MS Access MVP


Karla V said:
I have a report that looks something like this:
Class Ques 1 Ques 2 Ques 3
Class 1 50 75 23
Class 2 23 99 52

Is there a way to use Conditional Formatting to format just the highest
value per record? So, in Class 1, format just '75' and in Class 2, format
just '99'?

Thanks -
Click to expand...
Click to expand...
 
Back
Top