formula is:

=ISNUMBER(MATCH(B3+5000,D3:Z3,0))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Justo170" wrote:

How to highlight one cell based on a range of cells?
For example, I want to highlight cell B3 when any cell D3:Z3 = B3+5000

A B C
D E
1 Van Number Last Oil Change Last Rotation 2
Weekending May 8 15
3 F1 31025 31025 30152 30540
4 F73 199583 199583 199447