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
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 vinod.ma...@gmail.com wrote:
Hi,
I want to know how to do a conditional formatting on numbers based on the
calculated percentage %
Please
Hi Sam,
But i am unable to put 0% to 2% to yellow.
On Sat, Sep 29, 2012 at 7:35 PM, vinod rao vinod.ma...@gmail.com 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
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 vinod.ma...@gmail.com 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 vinod.ma...@gmail.com wrote:
=(I3-J3)/J30 (RED)
=AND((I3-J3)/J3=0,(I3-J3)/J3=2%) (YELLOW)
=(I3-J3)/J35% (GREEN)
Find attachment also
Regards,
Sam Mathai CHacko
On Sat, Sep 29, 2012 at 8:39 PM, vinod rao vinod.ma...@gmail.com wrote:
Any suggestions?
I need conditional formating Yellow when the delta is 0% +2%
Thank you very much Sam. It was perfect
On Sat, Sep 29, 2012 at 9:04 PM, Sam Mathai Chacko samde...@gmail.comwrote:
=(I3-J3)/J30 (RED)
=AND((I3-J3)/J3=0,(I3-J3)/J3=2%) (YELLOW)
=(I3-J3)/J35% (GREEN)
Find attachment also
Regards,
Sam Mathai CHacko
On Sat, Sep 29, 2012 at 8:39 PM, vinod