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

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...
--
HTH...

Jim Thomlinson


"EXCEL USER" wrote:

> 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

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

"Jim Thomlinson" wrote:

> 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...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "EXCEL USER" wrote:
>
> > 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

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

--
HTH...

Jim Thomlinson


"EXCEL USER" wrote:

> 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
>
> "Jim Thomlinson" wrote:
>
> > 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...
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "EXCEL USER" wrote:
> >
> > > 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