Highlight number one issue?

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

Guest

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?
 
You can use conditional formatting to do this. If you need more direction,
you need to tell us how "number one" is determined.
 
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...
 
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.
 
Back
Top