colour highlight with conditional formating for partial dates?

Isabellalearning

New member
Joined
Oct 23, 2014
Messages
7
Reaction score
0
Points
0
Hello,

as per heat map tab in attached..

I am hoping its possible to use conditional formatting to show when any date (mm/yy and disregard dd) shows up more than twice highlight red? eg:if oct- 14 appears twice highlight red, if nov-14 shows up more than twice hightlight red etc?

Izzy
 

Attachments

  • test sample.xlsx
    32.9 KB · Views: 6
Use a formula of

=AND(ISNUMBER(E3),COUNTIF($E$3:R$24,E3)>1)
 
Back
Top