Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
CONDITIONAL FORMATTING IN EXCEL 2010
5 views
Skip to first unread message
Malcolm Austin
May 16, 2013, 7:08:23 AM5/16/13
to
Sorry, this is obviously a really simply one, but the help comments are not
making sense to me!
I wish to format A1 (background colour) when its value is higher than B1.
As in:-
A1 = 3.3% B1 = 2.8% so cell A1 background colour will change.
Thanks for the help!
Malcolm..
making sense to me!
I wish to format A1 (background colour) when its value is higher than B1.
As in:-
A1 = 3.3% B1 = 2.8% so cell A1 background colour will change.
Thanks for the help!
Malcolm..
Claus Busch
May 16, 2013, 7:20:24 AM5/16/13
to
Hi Malcom,
Am Thu, 16 May 2013 12:08:23 +0100 schrieb Malcolm Austin:
> I wish to format A1 (background colour) when its value is higher than B1.
>
> As in:-
>
> A1 = 3.3% B1 = 2.8% so cell A1 background colour will change.
select A1 => Conditional Formating => New Rule => Use formula to
determine which cells to format and enter the formula:
=A1>B1 and choose your expected format
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Am Thu, 16 May 2013 12:08:23 +0100 schrieb Malcolm Austin:
> I wish to format A1 (background colour) when its value is higher than B1.
>
> As in:-
>
> A1 = 3.3% B1 = 2.8% so cell A1 background colour will change.
determine which cells to format and enter the formula:
=A1>B1 and choose your expected format
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0 new messages