Formula want to know (urgent)
Closed
Shankar
-
Aug 4, 2016 at 10:41 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 4, 2016 at 01:06 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 4, 2016 at 01:06 PM
Related:
- Formula want to know (urgent)
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 4, 2016 at 01:06 PM
Aug 4, 2016 at 01:06 PM
Shankar, Good afternoon.
Scenario:
A1 = 200
B1 =
C1 =
D1 =
E1 = 300
Select: B1:D1
Menu Conditional Format
New Rule
a)
=B1<$A$1
Choose Format Color you want
OK
New Rule
b)
=B1>$E$1
Choose Format Color you want
OK
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Scenario:
A1 = 200
B1 =
C1 =
D1 =
E1 = 300
Select: B1:D1
Menu Conditional Format
New Rule
a)
=B1<$A$1
Choose Format Color you want
OK
New Rule
b)
=B1>$E$1
Choose Format Color you want
OK
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
