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
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
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
