Formula want to know (urgent)
Closed
Shankar
-
4 Aug 2016 à 10:41
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 4 Aug 2016 à 13:06
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 4 Aug 2016 à 13:06
Related:
- Formula want to know (urgent)
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
4 Aug 2016 à 13:06
4 Aug 2016 à 13:06
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
