Conditional formatting between
Closed
Bennett4
Posts
1
Registration date
Sunday 24 August 2014
Status
Member
Last seen
24 August 2014
-
24 Aug 2014 à 18:57
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 27 Aug 2014 à 06:04
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 27 Aug 2014 à 06:04
Related:
- Conditional formatting between
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- Risk formatting excel - Excel Forum
- Formatting windows 7 - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
27 Aug 2014 à 06:04
27 Aug 2014 à 06:04
see sample data
28 77 36
92 50 51
97 30 54
30 69 55
91 61 75
75 72 25
41 48 38
100 24 22
90 34 73
6 58 76
select C1
control c
select c1 to last c
choose paste icon-pastespecial-fomratg
ok
in the conditional format choose formulas and use this formula
=AND(C1>=MIN(A1,B1), C1<=MAX(A1,B1))
click format
choose "fill" at the top and the color
clilck ok
28 77 36
92 50 51
97 30 54
30 69 55
91 61 75
75 72 25
41 48 38
100 24 22
90 34 73
6 58 76
select C1
control c
select c1 to last c
choose paste icon-pastespecial-fomratg
ok
in the conditional format choose formulas and use this formula
=AND(C1>=MIN(A1,B1), C1<=MAX(A1,B1))
click format
choose "fill" at the top and the color
clilck ok
