0

Here is a sample of my spreadsheet:

enter image description here

I'd like to highlight with bold the earliest date in the yellow / red / blue ranges, without taking into account cells of the other two colours.

0

This one custom formatting rule, applied to the range D2:P, should work:

=ARRAYFORMULA(AND(D2<>"",MOD(COLUMN(D2),3)=1,D2=MIN(IF($C$2:$O<>C2,"",$D$2:$P))))
  • Thanks, this works well for the yellow and blue categories, but it doesn't highlight anything in the red. It only highlights a date in that category if the cell value is set to 2020-01-18 or earlier. – kazerniel Feb 17 at 13:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.