Formula want to know (urgent)

Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
There is a two values, i.e 200 & 300 in two cell. Now we want the values which is in between that figure in different cell means value should not exceed 300 and not to decrease 200. if values got exceed 300 or decrease 200 then high light the values in different two colours.

1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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