conditional formatting of cells
 

Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash, or
in some way show up to be recognized?

conditional formatting of cells
 

http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"cell formatting" <cell wrote in
message ...
Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash,
or
in some way show up to be recognized?

conditional formatting of cells
 

Select the cell you want this to apply to (assume it is A1), then
Format | Conditional Formatting and in the pop-up panel you should
first select Formula Is rather than Cell Contents from the drop-down.
In the next panel enter the following:

=A1<TODAY()

Then click on the Format button and then the Patterns tab (for
background colour) and select the colour you want to use. Click OK
twice to get out of this and test it by putting different dates in A1.
You can use the Format Painter to copy this format to other cells.

Hope this helps.

Pete

On Aug 7, 10:38 pm, cell formatting <cell
wrote:
Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash, or
in some way show up to be recognized?

conditional formatting of cells
 

I followed the directions and upon entering a date before today's date,
nothing happened to the cell. Help?

"Pete_UK" wrote:

Select the cell you want this to apply to (assume it is A1), then
Format | Conditional Formatting and in the pop-up panel you should
first select Formula Is rather than Cell Contents from the drop-down.
In the next panel enter the following:

=A1<TODAY()

Then click on the Format button and then the Patterns tab (for
background colour) and select the colour you want to use. Click OK
twice to get out of this and test it by putting different dates in A1.
You can use the Format Painter to copy this format to other cells.

Hope this helps.

Pete

On Aug 7, 10:38 pm, cell formatting <cell
wrote:
Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash, or
in some way show up to be recognized?

conditional formatting of cells
 

I followed the directions and upon entering a date before today's date,
nothing happened to the cell. Help?

"Pete_UK" wrote:

Select the cell you want this to apply to (assume it is A1), then
Format | Conditional Formatting and in the pop-up panel you should
first select Formula Is rather than Cell Contents from the drop-down.
In the next panel enter the following:

=A1<TODAY()

Then click on the Format button and then the Patterns tab (for
background colour) and select the colour you want to use. Click OK
twice to get out of this and test it by putting different dates in A1.
You can use the Format Painter to copy this format to other cells.

Hope this helps.

Pete

On Aug 7, 10:38 pm, cell formatting <cell
wrote:
Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash, or
in some way show up to be recognized?

conditional formatting of cells
 

Nothing will occur if the date in A1 does not exceed today's date.

Try =A1TODAY()


Gord Dibben MS Excel MVP



On Wed, 8 Aug 2007 14:28:02 -0700, cell formatting
wrote:

I followed the directions and upon entering a date before today's date,
nothing happened to the cell. Help?

"Pete_UK" wrote:

Select the cell you want this to apply to (assume it is A1), then
Format | Conditional Formatting and in the pop-up panel you should
first select Formula Is rather than Cell Contents from the drop-down.
In the next panel enter the following:

=A1<TODAY()

Then click on the Format button and then the Patterns tab (for
background colour) and select the colour you want to use. Click OK
twice to get out of this and test it by putting different dates in A1.
You can use the Format Painter to copy this format to other cells.

Hope this helps.

Pete

On Aug 7, 10:38 pm, cell formatting <cell
wrote:
Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash, or
in some way show up to be recognized?

conditional formatting of cells
 

Nothing will occur if the date in A1 does not exceed today's date.

Try =A1TODAY()


Gord Dibben MS Excel MVP



On Wed, 8 Aug 2007 14:28:02 -0700, cell formatting
wrote:

I followed the directions and upon entering a date before today's date,
nothing happened to the cell. Help?

"Pete_UK" wrote:

Select the cell you want this to apply to (assume it is A1), then
Format | Conditional Formatting and in the pop-up panel you should
first select Formula Is rather than Cell Contents from the drop-down.
In the next panel enter the following:

=A1<TODAY()

Then click on the Format button and then the Patterns tab (for
background colour) and select the colour you want to use. Click OK
twice to get out of this and test it by putting different dates in A1.
You can use the Format Painter to copy this format to other cells.

Hope this helps.

Pete

On Aug 7, 10:38 pm, cell formatting <cell
wrote:
Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash, or
in some way show up to be recognized?