How Conditional Formatting can halt when multiple cells have same value

[Ram Mher]

I have data from A1:A5
A1=1
A2=2
A3=3
A4=2
A5=3

File is attached and conditional formatting is implemented to evaluate deeply.

Required:-

How single cell will highlight when more than one cells having same value like 3
I have implemented conditional formatting and rule is taken top 1 value.

 

[Somendra Misra]

Hi Ram,

The file is not attached. But see this file.

Regards,

 

[Ram Mher]

@ somendra
Thanks friend
i need the highlighting for the top 1 value only. Pls find the attached and suggest

 

[Syedali]

@ somendra
Thanks friend
i need the highlighting for the top 1 value only. Pls find the attached and suggest

Hi,
Please do in following way
1. Select the range which you want (b13:b17)
2. click CF
3. Manage rules
4. New rule
5. Select rule type "Format only top or bottom ranked values
6. In edit rule description select "top", and type "1".

I am sure you will get answer.

Thanks

 

[Somendra Misra]

Sorry Ram, I am not getting this in PT.

Regards,

 

[Ram Mher]

n

Hi,
Please do in following way
1. Select the range which you want (b13:b17)
2. click CF
3. Manage rules
4. New rule
5. Select rule type "Format only top or bottom ranked values
6. In edit rule description select "top", and type "1".

I am sure you will get answer.

Thanks

not sucessful method friend

 

[Ram Mher]

Sorry Ram, I am not getting this in PT.

Regards,

@ somendra
you are genius in excel and think that it is not a big issue for u friend. pls find any other soultion

 

[Somendra Misra]

@Ram Mher

Thanks for your kind words. See this file.

Regards,

 

[Syedali]

@Ram Mher

Thanks for your kind words. See this file.

Regards,

Wow Awesome Sir . Kindly guide me how it works.

 

[Somendra Misra]

@Syedali

There is simple formula in CF, which checks for two condition:
1. Where the cell value is equal to max of the column.
2. Where the count of current cell in a row is equal to total count of that value in that column.

Regards,