Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 543
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
We have the following sheet
We want to highlight the cell with "green colour" if P8 value will "equal or less" (F7:J11)
We want to highlight the cell with "red colour" if P9 value will "equal or less" (F7:J11)
We required only formula not vba
help pls
We have the following sheet
Book2 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Head1 | Head2 | Head3 | Head4 | Head5 | Head6 | Head7 | Head8 | Head9 | Head10 | Head11 | Head12 | Head13 | |||||
2 | P1 | Dewod | LOG | 1 | 291.3 | 292.65 | 309.85 | 285.5 | 294.05 | 295.65 | 300.14 | 1461205 | 33559 | |||||
3 | P2 | Dewod | LOG | 2 | 295.65 | 297 | 307.85 | 290 | 290.5 | 290.9 | 299.85 | 834491 | 17572 | |||||
4 | P3 | Dewod | LOG | 3 | 290.9 | 292 | 296.3 | 287.1 | 288.5 | 289.6 | 291.73 | 338885 | 7760 | |||||
5 | P4 | Dewod | LOG | 4 | 289.6 | 293 | 293.25 | 287.55 | 289.5 | 290.75 | 290.18 | 270134 | 4960 | |||||
6 | ||||||||||||||||||
7 | P5 | Dewod | LOG | 5 | 290.75 | 291.95 | 295.95 | 289.5 | 293 | 293.8 | 293.32 | 655749 | 10394 | |||||
8 | P6 | Dewod | LOG | 6 | 293.8 | 296.5 | 296.7 | 290.2 | 291.25 | 291.25 | 292.94 | 246510 | 4986 | Test 1 | 290.2 | 290.7 | ||
9 | P7 | Dewod | LOG | 7 | 291.25 | 293.15 | 293.15 | 287.15 | 289.05 | 289.45 | 289.63 | 252697 | 5332 | Test 2 | 289.05 | 289.55 | ||
10 | P8 | Dewod | LOG | 8 | 289.45 | 290 | 293 | 287.45 | 290.05 | 290.05 | 290.49 | 319302 | 8201 | |||||
11 | P9 | Dewod | LOG | 9 | 290.05 | 290.4 | 297.45 | 290 | 291.65 | 292.55 | 293.41 | 458829 | 7819 | |||||
12 | ||||||||||||||||||
13 | P10 | Dewod | LOG | 10 | 292.55 | 292 | 294 | 290.6 | 292.05 | 291.9 | 292.19 | 170188 | 3548 | |||||
14 | P11 | Dewod | LOG | 11 | Test 1 | 318.2 | 318.7 | |||||||||||
15 | P12 | Dewod | LOG | 12 | 293.2 | 294.75 | 306.5 | 293.3 | 303.75 | 303.35 | 301.84 | 929976 | 20706 | Test 2 | 292.05 | 292.55 | ||
16 | P13 | Dewod | LOG | 13 | 303.35 | 303.95 | 325 | 303.95 | 322 | 321.65 | 317.2 | 2047615 | 39419 | |||||
17 | P14 | Dewod | LOG | 14 | 321.65 | 319 | 337 | 318.2 | 327.15 | 327.75 | 328.97 | 1580688 | 32300 | |||||
Sheet1 |
We want to highlight the cell with "green colour" if P8 value will "equal or less" (F7:J11)
We want to highlight the cell with "red colour" if P9 value will "equal or less" (F7:J11)
We required only formula not vba
help pls