Prev: Ink on a Protected Sheet
Next: Conditional Formatting
From: Shihachi on 20 Jan 2010 11:26
I have trying to do this, but to no avail.
I want cells to change color like:
more than 60 days before certain date - they're green
1 - 60 days - they're yellow
0 days and days after - they're red
From: Jim Thomlinson on 20 Jan 2010 13:06
Format | Conditional Format | Cell Value is < A1-60 where the date to check
against is in cell A1. Define your Format.

Same for the other formats
--
HTH...

Jim Thomlinson


"Shihachi" wrote:

> I have trying to do this, but to no avail.
> I want cells to change color like:
> more than 60 days before certain date - they're green
> 1 - 60 days - they're yellow
> 0 days and days after - they're red
From: Shihachi on 20 Jan 2010 14:17
i use excel 2007

"Jim Thomlinson" wrote:

> Format | Conditional Format | Cell Value is < A1-60 where the date to check
> against is in cell A1. Define your Format.
>
> Same for the other formats
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Shihachi" wrote:
>
> > I have trying to do this, but to no avail.
> > I want cells to change color like:
> > more than 60 days before certain date - they're green
> > 1 - 60 days - they're yellow
> > 0 days and days after - they're red
From: Bernard Liengme on 22 Jan 2010 09:46
Conditional Formatting is on the Home tab
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Shihachi" <Shihachi(a)discussions.microsoft.com> wrote in message
news:0EF02C0D-301E-4F0F-9B8A-6AE775419393(a)microsoft.com...
> i use excel 2007
>
> "Jim Thomlinson" wrote:
>
>> Format | Conditional Format | Cell Value is < A1-60 where the date to
>> check
>> against is in cell A1. Define your Format.
>>
>> Same for the other formats
>> --
>> HTH...
>>
>> Jim Thomlinson
>>
>>
>> "Shihachi" wrote:
>>
>> > I have trying to do this, but to no avail.
>> > I want cells to change color like:
>> > more than 60 days before certain date - they're green
>> > 1 - 60 days - they're yellow
>> > 0 days and days after - they're red

 | 
Pages: 1
Prev: Ink on a Protected Sheet
Next: Conditional Formatting