Conditional Formatting

[Karla V]

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 -

 

[Duane Hookom]

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]

 

[Karla V]

Excellent - works great! Thank you so much!

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

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 -