Hi,
I Use this =OR((MOD(O2,10)=3),(MOD(O2,10)=4),(MOD(O2,10)=8),(MOD(O2,10)=9))
conditional formatting equation to highlight cells with 3,4,8 and 9 in the ones position. but the equation is fixed on the O. Is there a way the equation will change depending on the selected cells?
thanks
I Use this =OR((MOD(O2,10)=3),(MOD(O2,10)=4),(MOD(O2,10)=8),(MOD(O2,10)=9))
conditional formatting equation to highlight cells with 3,4,8 and 9 in the ones position. but the equation is fixed on the O. Is there a way the equation will change depending on the selected cells?
testing vba.xlsx | |||
---|---|---|---|
M | |||
1 | Total | ||
2 | 0 | ||
3 | 47 | ||
4 | 49 | ||
5 | 58 | ||
6 | 56 | ||
7 | 69 | ||
8 | 76 | ||
9 | 54 | ||
10 | 82 | ||
11 | 67 | ||
12 | 62 | ||
13 | 59 | ||
14 | 58 | ||
15 | 76 | ||
16 | 59 | ||
17 | 75 | ||
18 | 56 | ||
19 | 48 | ||
20 | 71 | ||
21 | 94 | ||
22 | 78 | ||
23 | 79 | ||
24 | 68 | ||
25 | 63 | ||
26 | 73 | ||
27 | 91 | ||
28 | 76 | ||
29 | 97 | ||
30 | 63 | ||
31 | 98 | ||
32 | 86 | ||
33 | 94 | ||
34 | 79 | ||
35 | 67 | ||
36 | 83 | ||
37 | 81 | ||
38 | 83 | ||
39 | 74 | ||
40 | 74 | ||
41 | 82 | ||
42 | 74 | ||
43 | 82 | ||
44 | 93 | ||
45 | 60 | ||
Sheet1 (2) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
M2 | Expression | =OR((MOD(activecell,10)=3),(MOD(activecell,10)=4),(MOD(activecell,10)=8),(MOD(activecell,10)=9)) | text | NO |
thanks