Highlight number one issue?

[hursty]

I have a report that sums the number of defects in about 50 different
categories. Is there any way to highlight or make the number one issue stand
out every time?

 

[Duane Hookom]

You can use conditional formatting to do this. If you need more direction,
you need to tell us how "number one" is determined.

 

[hursty]

Basically here is what the report looks like...

A B C D E

a 0 5 9 45 2

b 8 0 5 5 9

c 0 4 6 48 6

d 8 5 32 0 4


I want the report to highlight or make red or something the top 2 or 3
values. For example I would want D-a and D-c and C-d to be bright red. I'm
guessing the conditional formatting can do it but I don't know how. I know
that excel has a Large() Function that can find the biggest...

 

[Duane Hookom]

There is a huge difference between "highlight or make the number one issue"
and "top 2 or 3".
To highlight the top one:
- Add a report header section
- Add a text box
Name: txtMaxA
Control Source: =Max([A])
- Select the [A] control in the detail section
- Select conditional formatting and set the Expression Is to something like:
[A] = [txtMaxA]
- Set the formatting as required.
- Do the same for the other columns/text boxes.