Conditional Formating based on Date
in [General]
|
Prev: How do I merge two cells without deleting data from the cell?
Next: How do I control the light/dark variations Excel 2007 color theme?
From: Kimti on 7 Mar 2010 17:32 Now blanks are showing yellow. Please help. "Per Jessen" wrote: > Change condition 1 to: > > =AND(A1<=TODAY(),A1>0) > > Regards, > Per > > On 7 Mar., 21:47, Kimti <Ki...(a)discussions.microsoft.com> wrote: > > I would like to change the cell color based on date. For example if date is > > today or less color should be red, if date is upto 10 days from today the > > color should be yellow. I used following: > > Condition 1: =A1<=today() RED > > Condition 2: =A1-today()<10 YELLOW > > > > it worked ok if I have date in the cell. If the cell is empty, it is still > > showing me RED color. I want see no formatting if the cell is empty. > > > > Thank you in advance for your kind help. > > . >
From: ck on 7 Mar 2010 23:17 Hi Kimti, Try this to see if works: condition 1: =AND(A1<=TODAY(),A1<>"") condition 2: =AND(A1-TODAY()<10,A1<>"") Click yes below if it works for you. "Kimti" wrote: > Now blanks are showing yellow. Please help. > > "Per Jessen" wrote: > > > Change condition 1 to: > > > > =AND(A1<=TODAY(),A1>0) > > > > Regards, > > Per > > > > On 7 Mar., 21:47, Kimti <Ki...(a)discussions.microsoft.com> wrote: > > > I would like to change the cell color based on date. For example if date is > > > today or less color should be red, if date is upto 10 days from today the > > > color should be yellow. I used following: > > > Condition 1: =A1<=today() RED > > > Condition 2: =A1-today()<10 YELLOW > > > > > > it worked ok if I have date in the cell. If the cell is empty, it is still > > > showing me RED color. I want see no formatting if the cell is empty. > > > > > > Thank you in advance for your kind help. > > > > . > >
From: ck on 7 Mar 2010 23:18
Hi Kimti, Try this to see if it works for you: condition 1: =AND(A1<=TODAY(),A1<>"") condition 2: =AND(A1-TODAY()<10,A1<>"") Click yes below if it works. "Kimti" wrote: > Now blanks are showing yellow. Please help. > > "Per Jessen" wrote: > > > Change condition 1 to: > > > > =AND(A1<=TODAY(),A1>0) > > > > Regards, > > Per > > > > On 7 Mar., 21:47, Kimti <Ki...(a)discussions.microsoft.com> wrote: > > > I would like to change the cell color based on date. For example if date is > > > today or less color should be red, if date is upto 10 days from today the > > > color should be yellow. I used following: > > > Condition 1: =A1<=today() RED > > > Condition 2: =A1-today()<10 YELLOW > > > > > > it worked ok if I have date in the cell. If the cell is empty, it is still > > > showing me RED color. I want see no formatting if the cell is empty. > > > > > > Thank you in advance for your kind help. > > > > . > > |