Caution Signal

[Guest]

Hi, I need help..
I would like some caution signals in my workbook. If limit reaches over 75%
but Less than 100% that I like to fill some color and also bold the text and
also increase text size by one or two point level.

If the Limit reaches to 100% over 100% I like to text to go red, bolded and
that cell filled with some other color.

please help thanks

 

[Guest]

How about using a conditional format? (Format -> Conditional Format) Based on
your description you probably will need to base it on a formula. without more
details it is hard to comment further...

 

[Guest]

Hi, Jim
I am using conditional formula but it will be in three layers but it is not
comming out correctly.
Here I am using as follow
if cell value "Less than or Equal to" "$G$10*100% using color red
If cell value "Between" "$G$10*75% and $G$10*g10*99.99% using color Orange
If Cell Value Between "$G$10" and $G$10*74.99%" using no formatting but it
is not giving me correct result.

see if you can help May be i am making some simple stupid mistake it is been
very long day
thanks

 

[Guest]

Go with Formula Is and not Cell Value... Use a formula like

Criteria 1
=and($G$10>=0.75, $G$10<1)

Criteria 2
=$G$10>=1