Highlight the Date which have Highest Count

[Vibhuti Shrotriya]

Dear All,

I have data Like mentioned below :

Count Month

402 14-Apr

850 13-Feb

723 12-May

651 11-May

I want to Highlight the Date in Month Column Which have highest Count.

Output Example :

Count		Month
402		14-Apr
850		13-Feb
723		12-May
651		11-May

Kindly help.

Thanks

Vibhuti

[Ashish Bhalara]

Hi Vibhuti,

You can use conditional formatting to highlight date. I assume that Count column A and Month column is B and data start from B2. Follow the below step.

• Select range from B2 to end range of date.
  
• Goto Conditional Formatting menu from Home tab.
• Select 'New Rule' and go to rule type of 'Use a fromula to determine...'
• Write formula '=A2=MAX($A$2:$A5)' and complete action using OK button

you can see attached file for example

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/19a31a74-9eaa-4e5f-ac0b-3dd019542704%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Vibhuti Shrotriya]

Dear Ashish Bhalara,

Thanks a lot. This is working for me.

Thanks

Vibhuti