Conditional Format Percentage

[Mickey]

Hi,
How can I conditionally format a cell based on the percentage value of
another cell rather than the value of its own cell?. All values ar

Example, I wish to format "A1" based on the value of B1. If B1 = -5% then
A1 would colour Amber, if B1 = -10% then A1 would colour Red, if B1 => 0
then A1 would go Green.

Three format to apply -
(1) B1 => 0% [Green]
(2) B1 <= minus 9.99% [Red]
(3) B1 between minus 0.01% & -9.99% [Amber]

Can this be done, possibly in one formula for conditional formatting?

Thanks,
Mickey

 

[Chip Pearson]

In the Conditional Formatting dialog, change "Cell Value Is" to
"Formula Is" and enter a formula that returns TRUE (or any
non-zero value) or FALSE (or 0), and choose your formatting. The
format will be applied if the formula returns TRUE.

 

[Ragdyer]

Select A1, then:
<Format> <Conditional Format>
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1>=0

Click on "Format" and choose Green for the font.
Then <OK>

Click "Add",
And for condition 2,
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1>-0.0999

Click on "Format" and choose Amber (Lt. Orange) for the font.
Then <OK>

Click "Add",
And for condition 3,
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1<=0.0999

Click on "Format" and choose Red for the font.
Then <OK> <OK>

 

[Mickey]

Thanks for the responses, works great.

Mickey

Select A1, then:
<Format> <Conditional Format>
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1>=0

Click on "Format" and choose Green for the font.
Then <OK>

Click "Add",
And for condition 2,
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1>-0.0999

Click on "Format" and choose Amber (Lt. Orange) for the font.
Then <OK>

Click "Add",
And for condition 3,
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1<=0.0999

Click on "Format" and choose Red for the font.
Then <OK> <OK>

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Hi,
How can I conditionally format a cell based on the percentage value of
another cell rather than the value of its own cell?. All values ar

Example, I wish to format "A1" based on the value of B1. If B1 = -5%
then
A1 would colour Amber, if B1 = -10% then A1 would colour Red, if B1 => 0
then A1 would go Green.

Three format to apply -
(1) B1 => 0% [Green]
(2) B1 <= minus 9.99% [Red]
(3) B1 between minus 0.01% & -9.99% [Amber]

Can this be done, possibly in one formula for conditional formatting?

Thanks,
Mickey

 

[Ragdyer]

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Thanks for the responses, works great.

Mickey

Select A1, then:
<Format> <Conditional Format>
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1>=0

Click on "Format" and choose Green for the font.
Then <OK>

Click "Add",
And for condition 2,
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1>-0.0999

Click on "Format" and choose Amber (Lt. Orange) for the font.
Then <OK>

Click "Add",
And for condition 3,
Change 'Cell Value Is' to 'Formula Is',
And enter this in the next box:
=B1<=0.0999

Click on "Format" and choose Red for the font.
Then <OK> <OK>

--
HTH,

RD

--------------------------------------------------------------------------

-

Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-

Hi,
How can I conditionally format a cell based on the percentage value of
another cell rather than the value of its own cell?. All values ar

Example, I wish to format "A1" based on the value of B1. If B1 = -5%
then
A1 would colour Amber, if B1 = -10% then A1 would colour Red, if B1 => 0
then A1 would go Green.

Three format to apply -
(1) B1 => 0% [Green]
(2) B1 <= minus 9.99% [Red]
(3) B1 between minus 0.01% & -9.99% [Amber]

Can this be done, possibly in one formula for conditional formatting?

Thanks,
Mickey