I am trying to add conditional highligting for only 2 cells where the range has the same data.
IE:
A1:E1 with the exact same value of
6,0; 6,0; 6,0; 6,0; 6,0
The current formula I am using to highlight the 1st instance is:
=AND(A1=MAX($A1:$E1),COUNTIFS($A1:A1,A1)=1)
I NOW need to have 2 of these cells highlighted if ALL cells are the exact same value.
The reason for this is to id the 2 highlighted cells, of the 5, that will not be calculated.
IE:
A1:E1 with the exact same value of
6,0; 6,0; 6,0; 6,0; 6,0
The current formula I am using to highlight the 1st instance is:
=AND(A1=MAX($A1:$E1),COUNTIFS($A1:A1,A1)=1)
I NOW need to have 2 of these cells highlighted if ALL cells are the exact same value.
The reason for this is to id the 2 highlighted cells, of the 5, that will not be calculated.