# Conditional formatting Help

#### Papa Pro

##### New Member
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!

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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

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

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

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.

Papa Pro said:
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.

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.

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?

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.

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,

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

Replies
1
Views
697
Replies
0
Views
234
Replies
2
Views
114
Replies
3
Views
502
Replies
2
Views
398

1,202,965
Messages
6,052,836
Members
444,603
Latest member
dustinjmangum

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back