Conditional formatting Help

[Papa Pro]

Hi all,

I feel so dumb but after a day of trying I give up. Then I found you! All I want to do is highlight the highest number in red in my spread sheet columns. Nothing more. As I add data I want the highest number to auto red and the previous lower number to go back to black. I have looked at conditional formatting and found the “MAX” code can add the highest numbered cell in a column and display the date in that one cell. However, I want the columns to show the same cell in red in the column.

So, If I want say D8 to D20 to show the highest numbered cell or flash would be cool! (In RED the highest value in that column)

Thanks for anyone who can help and please go easy on me. I’m completely a beginner!

 

[shodan]

hi,

I think this will do:

=RANK(A1;$A$1:$A$7)=1

put this cond.format in first cell and copy down. equal highest number will both color red.

hope this is what you are looking for

 

[Norie]

Select D8:D20, goto conditional formatting, select Value is and enter this formula

=MAX($D$8:$D$20)

 

[Papa Pro]

Thanks for you quick response! But I am still confused. Here is the MAX I have in one cell giving me the highest number:

=MAX(C8:C36)

Now I need to know how to Highlight the highest number in the C Colum (between those ranges) and have and red highlight in that column. Once I have done this I have several more to do so understanding what I doing will help. I did spend quite a few hours here already but still learning the basics.

 

[Aladin Akyurek]

Thanks for you quick response! But I am still confused. Here is the MAX I have in one cell giving me the highest number:

=MAX(C8:C36)

Now I need to know how to Highlight the highest number in the C Colum (between those ranges) and have and red highlight in that column. Once I have done this I have several more to do so understanding what I doing will help. I did spend quite a few hours here already but still learning the basics.

Select C8:C36.
Activate Format|Conditional Formatting.
Choose Formula Is for Condition 1.
Invoke one of:

=$C8=MAX($C$8:$C$36)

=RANK($C8,$C$8:$C$36)=1

Activate the Format button
Choose red from the Patterns tab.
Click OK, OK.

 

[Norie]

Richard

What have you tried?

Do you want to highlight the maximum in C8:C36?

1 Select C8:C36.

2 Goto Format>Conditional Formatting...

3 Select Cell Value is and equal to.

4 Enter this formula =MAX($C$8:$C$36).

5 Hit Format>>> and format as required.

 

[Papa Pro]

Thanks so much to all for your help! =$C8=MAX($C$8:$C$36) worked a treat!!!

Now how do I make that cell flash?

 

[Norie]

Richard

The only way to make the cell flash would be through code.

The code would have to constantly be running and would probablyimpact on performance.

 

[Papa Pro]

No problem. I can not believe how excited I am about a spread sheet? I only want to log a e-bike range test over the next few months and this new sheet is fantastic thanks to you!

Take care all,

 

[Papa Pro]

I'm back!

Hi all,

I LOVE my spreadsheet!!! Many people are going to benefit (From our Group) so thanks to all!

Now I have this formula down to a T but I want to now add 1st, 2nd and 3rd in color code so can someone give me the codes? Also I really want to have a hyperlink to each sheet (names) so we can simply click on each others sheet for data. Can you guys explain how to do this?

Cheers,

Richard