Orangeanorak
Active Member
- Joined
- Nov 22, 2002
- Messages
- 276
- Office Version
- 365
- Platform
- Windows
conditional formatting?
I posted something similar to this some time ago but never got an answer and it 'fell off' the board. Here's hoping for a solution this time please.
1. Formula please to highlight the cell in column H that is equal to or nearest to J1 IF the cell in the same row in column J equals 7
2. Formula to highlight the cell in column B if the cell on the same row in column H is highlighted as a result of the above.
Thank you - your help is appreciated
I posted something similar to this some time ago but never got an answer and it 'fell off' the board. Here's hoping for a solution this time please.
1. Formula please to highlight the cell in column H that is equal to or nearest to J1 IF the cell in the same row in column J equals 7
2. Formula to highlight the cell in column B if the cell on the same row in column H is highlighted as a result of the above.
Excel Workbook | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | * | * | * | * | * | * | * | * | * | 17 | ||
2 | * | * | * | * | * | * | * | * | * | * | ||
3 | * | * | * | * | * | * | * | * | * | * | ||
4 | 1 | Red | * | * | * | * | * | 7 | * | 7 | ||
5 | 2 | Black | * | * | * | * | * | 8 | * | 7 | ||
6 | 3 | Blue | * | * | * | * | * | 17 | * | 3 | ||
7 | 4 | Green | * | * | * | * | * | 8 | * | 7 | ||
8 | 5 | White | * | * | * | * | * | 49 | * | 6 | ||
9 | 6 | Brown | * | * | * | * | * | 5 | * | 2 | ||
10 | 7 | Grey | * | * | * | * | * | 31 | * | 5 | ||
11 | 8 | Scarlet | * | * | * | * | * | 11 | * | 6 | ||
12 | 9 | Yellow | * | * | * | * | * | 13 | * | 5 | ||
13 | 10 | Orange | * | * | * | * | * | 22 | * | 1 | ||
Sheet |
Thank you - your help is appreciated