Conditional formatting between
Closed
Bennett4
Posts
1
Registration date
Sunday August 24, 2014
Status
Member
Last seen
August 24, 2014
-
Aug 24, 2014 at 06:57 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 27, 2014 at 06:04 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 27, 2014 at 06:04 AM
Related:
- Conditional formatting between
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Conditional formatting based on date ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 27, 2014 at 06:04 AM
Aug 27, 2014 at 06:04 AM
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
