Conditional Formatting

[Alleyezonme1148]

Question for you guys!

I am trying to use Conditional Formatting. I need the highest # to show RED, second highest # to show Orange, Third highest to show yellow. I am using cells D13 through D30.

I am not sure if I have to do the function for each CELL or what.

I already have a function in the cell....
"=COUNTA(Sheet2!B:B) - 2"

I do not think that would matter because I will be using the Conditional Formatting for the new function.

Any help would be great...Thanks!!

[sweep]

Hi,

Use = LARGE($D$13:$D$30,1) for the highest
= LARGE($D$13:$D$30,2) for the second highest and
= LARGE($D$13:$D$30,3) for the third highest

[Alleyezonme1148]

Would I put that in Conditional Formatting?

[Marcol]

Don't try this, it doesn't work!!!

Deleted data

Sorry about that.......

[sweep]

Condition 1
Cell Value > equal to
Code:
=RANK(1,$D$13:$D$30)
Applies to
=$D$13:$D$30

Format = Red

Won't that highlight the number that represents the rank that 1 has in the array D13:D30 ?

[Marcol]

Correct Sweep

I had it tied to another row of data and it seemed okay, didn't check it on its own.

Post "Deleted" as best as I can.

Cheers

[EDIT]
For the record it should have been

Condition 1 (highest)
=RANK(D13,$D$13:$D$30)=1

Condition 2
=RANK(D13,$D$13:$D$30)=2

Condition 3
=RANK(D13,$D$13:$D$30)=3

Thanks Sweep

[Alleyezonme1148]

Correct Sweep

I had it tied to another row of data and it seemed okay, didn't check it on its own.

Post "Deleted" as best as I can.

Cheers

[EDIT]
For the record it should have been

Condition 1 (highest)
=RANK(D13,$D$13:$D$30)=1

Condition 2
=RANK(D13,$D$13:$D$30)=2

Condition 3
=RANK(D13,$D$13:$D$30)=3

Thanks Sweep

Thank you so much.
That is perfect!