"Conditional formatting": Colored Font of one Cell Value in depence of the devia

U

U.W.

Dear all,

I am writing at my diploma thesis and I compare "as-is"-
values "V" with "to-be"-values "RV" in various excel books.
For a better overview I want to color the fonts in red,
yellow and green.

Example:

Cell V: 55 (should change color)
Cell RV: 60 (stays as it is)

So my question is:

In Cell V is one value, e.g. 55. In Cell RV is the
Reference Value, e.g. 60.
I want now something like "conditional formatting":

1.
If the value of Cell V is more than 10 % lower as the
Value of Cell RV, the font color of Cell V should turn
into red: e.g. V=51, RV=60
2.
If the value of Cell V is between 10% (included) and 0%
(not included) lower than in Cell RV, the font color of
Cell V should turn yellow: e.g. V=58, RV=60
3.
If the value of Cell V is equal (0% difference) or higher,
the font color of Cell V should turn green: e.g. V=62,
RV=60

Thanks for your help,
U.W.
 
F

Frank Kabel

Hi
try the following:
1. Select cell V1
2. Goto 'Format - Conditional Format' and enter the following formula
=V1<R1*0.9
and choose the red format

3. Add a condition and enter the formula
=(V1>=R1*0.9)*(V1<R1)
choose a yellow format and add another condition

4. Add the formula
=V1>=R1
and choose your format
 
U

U.W.

Dear Frank Kabel,

unbelievable fast! Thanks a lot for your help- it works in
my testfile. My work will be much more easier now ...
Thank you very much,

U.W.
 
Top