View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Justo170 Justo170 is offline
external usenet poster
 
Posts: 3
Default Conditional formatting

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