Hello,
From data column B5:F13 I want Conditional formatting formulas odd even numbers like this is it possible
Odds between 1 to 23 fonts White highlight colour Red
Odds between 25 to 49 fonts White highlight colour Magenta
Evens between 2 to 24 fonts White highlight colour Green
Evens between 25 to 50 fonts White highlight colour Blue
Thank you all.
I am using Excel 2000
Regards,
Moti
From data column B5:F13 I want Conditional formatting formulas odd even numbers like this is it possible
Odds between 1 to 23 fonts White highlight colour Red
Odds between 25 to 49 fonts White highlight colour Magenta
Evens between 2 to 24 fonts White highlight colour Green
Evens between 25 to 50 fonts White highlight colour Blue
* | A | B | C | D | E | F | G | H |
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 | 9 | 13 | 21 | 29 | 35 | |||
6 | 2 | 3 | 13 | 17 | 21 | |||
7 | 2 | 10 | 16 | 42 | 50 | |||
8 | 16 | 21 | 27 | 30 | 32 | |||
9 | 7 | 32 | 39 | 40 | 45 | |||
10 | 16 | 28 | 32 | 44 | 48 | |||
11 | 12 | 34 | 37 | 38 | 42 | |||
12 | 18 | 23 | 37 | 41 | 42 | |||
13 | 2 | 10 | 18 | 34 | 35 | |||
14 | 4 | 10 | 27 | 38 | 40 | |||
15 | ||||||||
16 | ||||||||
17 | ||||||||
18 |
Thank you all.
I am using Excel 2000
Regards,
Moti