Prev: Insert Code
Next: MULTIPLE COPYING OF ONE WORKSHEET
From: ian on 27 Feb 2010 14:05
I am trying to format a cell based upon the relationship of another cell to a
reference value. For instance if the reference is 5 and the other cell is 4
I want to format the original cell green, if it is the same blue and if it is
less than the reference red.

Can someone help please!
From: Russell Dawson on 27 Feb 2010 15:23
Please give a full explanation
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"ian" wrote:

> I am trying to format a cell based upon the relationship of another cell to a
> reference value. For instance if the reference is 5 and the other cell is 4
> I want to format the original cell green, if it is the same blue and if it is
> less than the reference red.
>
> Can someone help please!
From: Fred Smith on 27 Feb 2010 17:20
You can do this with conditional formatting. Say A1 is the cell you want
formatted, and B1 is your other cell. Then use:
=a1>b1
Select green color
=a1=b1
Select blue color
=a1<b1
Select red color

If you need further help, post back with the version of Excel you are using,
and the specifics on what cells you are using.

Regards,
Fred

"ian" <ian(a)discussions.microsoft.com> wrote in message
news:BA4C0F0E-D037-47B4-BD39-6B10392EC88F(a)microsoft.com...
>I am trying to format a cell based upon the relationship of another cell to
>a
> reference value. For instance if the reference is 5 and the other cell is
> 4
> I want to format the original cell green, if it is the same blue and if it
> is
> less than the reference red.
>
> Can someone help please!

From: T. Valko on 27 Feb 2010 17:27
What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"ian" <ian(a)discussions.microsoft.com> wrote in message
news:BA4C0F0E-D037-47B4-BD39-6B10392EC88F(a)microsoft.com...
>I am trying to format a cell based upon the relationship of another cell to
>a
> reference value. For instance if the reference is 5 and the other cell is
> 4
> I want to format the original cell green, if it is the same blue and if it
> is
> less than the reference red.
>
> Can someone help please!


 | 
Pages: 1
Prev: Insert Code
Next: MULTIPLE COPYING OF ONE WORKSHEET