Forum Discussion

Margaret_D's avatar
Margaret_D
Copper Contributor
May 31, 2024

Conditional formatting across multiple columns

Hi    Is there a way that you can do conditional formatting across 4 columns but 1 row? I have got a spreadsheet that has got 4 different projects on, with date columns, and I want to highlight if...
excel
Formulas and Functions
KamikawaKazuma's avatar
KamikawaKazuma
Copper Contributor
May 31, 2024

Margaret_D 

Hi Maggie, 

The following formula works as attached.
"=COUNTIFS(OFFSET($A2,,,,4),A2)>1"
(Replace "$A2" as needed.)

 

dscheikey's avatar
dscheikey
Bronze Contributor
May 31, 2024

KamikawaKazuma 

OFFSET() is not absolutely necessary.

=COUNTIF($A2:$D2,A2)>1

Works too!