Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Good day,
Trying to get 1 conditional format formula that looks at 3 columns (F5:F29, I5:I29, L5:L29) of data and highlights A5 if A5 data is not found in all 3 together.
This is what I currently have but I'm not sure how to scale this up to what I need.
Trying to get 1 conditional format formula that looks at 3 columns (F5:F29, I5:I29, L5:L29) of data and highlights A5 if A5 data is not found in all 3 together.
This is what I currently have but I'm not sure how to scale this up to what I need.
Rich (BB code):
=NOT(COUNTIF($F$5:$F$29, A5)