Thank you very much Sam. It was perfect
On Sat, Sep 29, 2012 at 9:04 PM, Sam Mathai Chacko wrote:
> =(I3-J3)/J3<0 (RED)
> =AND((I3-J3)/J3>=0,(I3-J3)/J3<=2%) (YELLOW)
> =(I3-J3)/J3>5% (GREEN)
>
> Find attachment also
>
> Regards,
> Sam Mathai CHacko
>
>
> On Sat, Sep 29, 2012 at 8:39 PM, vinod rao
=(I3-J3)/J3<0 (RED)
=AND((I3-J3)/J3>=0,(I3-J3)/J3<=2%) (YELLOW)
=(I3-J3)/J3>5% (GREEN)
Find attachment also
Regards,
Sam Mathai CHacko
On Sat, Sep 29, 2012 at 8:39 PM, vinod rao wrote:
>
> Any suggestions?
>
>
> I need conditional formating Yellow when the delta is 0% +2%
>
> Thanks,
> Vin
> O
Any suggestions?
I need conditional formating Yellow when the delta is 0% +2%
Thanks,
Vin
On Sat, Sep 29, 2012 at 7:53 PM, vinod rao wrote:
> Hi Sam,
>
> But i am unable to put 0% to 2% to yellow.
> On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote:
>
>> Hi,
>>
>> I want to know how to do a c
Hi Sam,
But i am unable to put 0% to 2% to yellow.
On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote:
> Hi,
>
> I want to know how to do a conditional formatting on numbers based on the
> calculated percentage %
> Please see attached file. Help me as quick as possible.
>
> Thanks
> Vin
>
>
> --
>
http://www.excelfox.com/forum/f2/conditional-format-based-percentage-variance-585/
Regards,
Sam Mathai Chacko
On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote:
> Hi,
>
> I want to know how to do a conditional formatting on numbers based on the
> calculated percentage %
> Please see attached fil
Hi,
I want to know how to do a conditional formatting on numbers based on the
calculated percentage %
Please see attached file. Help me as quick as possible.
Thanks
Vin
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANN
