Cell color date sensitive
 

Folks,

I am trying to build a tracking product for training events that are
accomplished and those that are due. I want to have a €œcell€� that turns from
Green €“ Yellow €“ Red, based on a timeframe that I pick. Example: John Doe
completes yearly Egress training on 1-18-2008 that cell will remain Green
until 3 months from his due date and then the cell will turn Yellow. At the
date that Egress training is due again the cell will turn Red until the
training is completed. I hope that I have not confused anyone€¦ your help in
this will make my job easier to track upcoming and overdue training.

--
RGM

Cell color date sensitive
 

The feature you need is called Conditional Formatting. You can access it by
doing Format ConditionalFormatting and following the menus. You can
invoke a base color to the cell, and 3 conditional ones. Try it, and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote:

Folks,

I am trying to build a tracking product for training events that are
accomplished and those that are due. I want to have a €œcell€� that turns from
Green €“ Yellow €“ Red, based on a timeframe that I pick. Example: John Doe
completes yearly Egress training on 1-18-2008 that cell will remain Green
until 3 months from his due date and then the cell will turn Yellow. At the
date that Egress training is due again the cell will turn Red until the
training is completed. I hope that I have not confused anyone€¦ your help in
this will make my job easier to track upcoming and overdue training.

--
RGM

Cell color date sensitive
 

I am sorry €œCLR€� I am not fluent in Code. Can you give me an example of how
to write the string using todays date and have the cell Green. Maybe then I
can go in and modify it for the rest of my tracking.
--
RGM


"CLR" wrote:

The feature you need is called Conditional Formatting. You can access it by
doing Format ConditionalFormatting and following the menus. You can
invoke a base color to the cell, and 3 conditional ones. Try it, and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote:

Folks,

I am trying to build a tracking product for training events that are
accomplished and those that are due. I want to have a €œcell€� that turns from
Green €“ Yellow €“ Red, based on a timeframe that I pick. Example: John Doe
completes yearly Egress training on 1-18-2008 that cell will remain Green
until 3 months from his due date and then the cell will turn Yellow. At the
date that Egress training is due again the cell will turn Red until the
training is completed. I hope that I have not confused anyone€¦ your help in
this will make my job easier to track upcoming and overdue training.

--
RGM

Cell color date sensitive
 

Format ConditionalFormatting FormulaIs: =$A1=TODAY() FormatButton
PatternsTab Pick a color OK OK

Vaya con Dios,
Chuck, CABGx3

"mcneilr" wrote:

I am sorry €œCLR€� I am not fluent in Code. Can you give me an example of how
to write the string using todays date and have the cell Green. Maybe then I
can go in and modify it for the rest of my tracking.
--
RGM


"CLR" wrote:

The feature you need is called Conditional Formatting. You can access it by
doing Format ConditionalFormatting and following the menus. You can
invoke a base color to the cell, and 3 conditional ones. Try it, and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote:

Folks,

I am trying to build a tracking product for training events that are
accomplished and those that are due. I want to have a €œcell€� that turns from
Green €“ Yellow €“ Red, based on a timeframe that I pick. Example: John Doe
completes yearly Egress training on 1-18-2008 that cell will remain Green
until 3 months from his due date and then the cell will turn Yellow. At the
date that Egress training is due again the cell will turn Red until the
training is completed. I hope that I have not confused anyone€¦ your help in
this will make my job easier to track upcoming and overdue training.

--
RGM

Cell color date sensitive
 

CONDITION 1 =E4:E991=TODAY()
CONDITION 2 OK that worked, now for me to project out 9 months and have that
date turn Yellow??????????????
CONDITION 3, Now if the training expires 12 months from todays date
Thank You...
RGM


"CLR" wrote:

Format ConditionalFormatting FormulaIs: =$A1=TODAY() FormatButton
PatternsTab Pick a color OK OK

Vaya con Dios,
Chuck, CABGx3

"mcneilr" wrote:

I am sorry €œCLR€� I am not fluent in Code. Can you give me an example of how
to write the string using todays date and have the cell Green. Maybe then I
can go in and modify it for the rest of my tracking.
--
RGM


"CLR" wrote:

The feature you need is called Conditional Formatting. You can access it by
doing Format ConditionalFormatting and following the menus. You can
invoke a base color to the cell, and 3 conditional ones. Try it, and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote:

Folks,

I am trying to build a tracking product for training events that are
accomplished and those that are due. I want to have a €œcell€� that turns from
Green €“ Yellow €“ Red, based on a timeframe that I pick. Example: John Doe
completes yearly Egress training on 1-18-2008 that cell will remain Green
until 3 months from his due date and then the cell will turn Yellow. At the
date that Egress training is due again the cell will turn Red until the
training is completed. I hope that I have not confused anyone€¦ your help in
this will make my job easier to track upcoming and overdue training.

--
RGM

Cell color date sensitive
 

I think maybe using =TODAY() will mess you up in the long run............
This should work better...........

Use CellValueIs: equal to =$A$1 for the base date you wish to
reference
CellValueIs: equal to =$A$1+270 for 9 months later
CellValueIs: equal to =$A$1+365 for one year later

Presuming A1 is where a date is that you wish to reference........you can of
course put it in any other cell.........just change A1 to that cell number.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote in message
...
CONDITION 1 =E4:E991=TODAY()
CONDITION 2 OK that worked, now for me to project out 9 months and have
that
date turn Yellow??????????????
CONDITION 3, Now if the training expires 12 months from todays date
Thank You...
RGM


"CLR" wrote:

Format ConditionalFormatting FormulaIs: =$A1=TODAY()
FormatButton
PatternsTab Pick a color OK OK

Vaya con Dios,
Chuck, CABGx3

"mcneilr" wrote:

I am sorry "CLR" I am not fluent in Code. Can you give me an example
of how
to write the string using today's date and have the cell Green. Maybe
then I
can go in and modify it for the rest of my tracking.
--
RGM


"CLR" wrote:

The feature you need is called Conditional Formatting. You can
access it by
doing Format ConditionalFormatting and following the menus. You
can
invoke a base color to the cell, and 3 conditional ones. Try it,
and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote:

Folks,

I am trying to build a tracking product for training events that
are
accomplished and those that are due. I want to have a "cell" that
turns from
Green - Yellow - Red, based on a timeframe that I pick. Example:
John Doe
completes yearly Egress training on 1-18-2008 that cell will
remain Green
until 3 months from his due date and then the cell will turn
Yellow. At the
date that Egress training is due again the cell will turn Red
until the
training is completed. I hope that I have not confused anyone.
your help in
this will make my job easier to track upcoming and overdue
training.

--
RGM

Cell color date sensitive
 

Thanks so much... Condition 1 works great, is there a way to perform a test
to check out Condition 2 & 3
--
RGM


"CLR" wrote:

I think maybe using =TODAY() will mess you up in the long run............
This should work better...........

Use CellValueIs: equal to =$A$1 for the base date you wish to
reference
CellValueIs: equal to =$A$1+270 for 9 months later
CellValueIs: equal to =$A$1+365 for one year later

Presuming A1 is where a date is that you wish to reference........you can of
course put it in any other cell.........just change A1 to that cell number.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote in message
...
CONDITION 1 =E4:E991=TODAY()
CONDITION 2 OK that worked, now for me to project out 9 months and have
that
date turn Yellow??????????????
CONDITION 3, Now if the training expires 12 months from todays date
Thank You...
RGM


"CLR" wrote:

Format ConditionalFormatting FormulaIs: =$A1=TODAY()
FormatButton
PatternsTab Pick a color OK OK

Vaya con Dios,
Chuck, CABGx3

"mcneilr" wrote:

I am sorry "CLR" I am not fluent in Code. Can you give me an example
of how
to write the string using today's date and have the cell Green. Maybe
then I
can go in and modify it for the rest of my tracking.
--
RGM


"CLR" wrote:

The feature you need is called Conditional Formatting. You can
access it by
doing Format ConditionalFormatting and following the menus. You
can
invoke a base color to the cell, and 3 conditional ones. Try it,
and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote:

Folks,

I am trying to build a tracking product for training events that
are
accomplished and those that are due. I want to have a "cell" that
turns from
Green - Yellow - Red, based on a timeframe that I pick. Example:
John Doe
completes yearly Egress training on 1-18-2008 that cell will
remain Green
until 3 months from his due date and then the cell will turn
Yellow. At the
date that Egress training is due again the cell will turn Red
until the
training is completed. I hope that I have not confused anyone.
your help in
this will make my job easier to track upcoming and overdue
training.

--
RGM

Cell color date sensitive
 

Put a string of about 20 dates or so down column B and do your formatting on
that column, except only use +1day and -1day, they whatever date you type in
A1, should light u 3 consecutive cells

Vaya con Dios,
Chuck, CABGx3


"mcneilr" wrote in message
...
Thanks so much... Condition 1 works great, is there a way to perform a
test
to check out Condition 2 & 3
--
RGM


"CLR" wrote:

I think maybe using =TODAY() will mess you up in the long
run............
This should work better...........

Use CellValueIs: equal to =$A$1 for the base date you wish to
reference
CellValueIs: equal to =$A$1+270 for 9 months later
CellValueIs: equal to =$A$1+365 for one year later

Presuming A1 is where a date is that you wish to reference........you
can of
course put it in any other cell.........just change A1 to that cell
number.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote in message
...
CONDITION 1 =E4:E991=TODAY()
CONDITION 2 OK that worked, now for me to project out 9 months and
have
that
date turn Yellow??????????????
CONDITION 3, Now if the training expires 12 months from todays date
Thank You...
RGM


"CLR" wrote:

Format ConditionalFormatting FormulaIs: =$A1=TODAY()
FormatButton
PatternsTab Pick a color OK OK

Vaya con Dios,
Chuck, CABGx3

"mcneilr" wrote:

I am sorry "CLR" I am not fluent in Code. Can you give me an
example
of how
to write the string using today's date and have the cell Green.
Maybe
then I
can go in and modify it for the rest of my tracking.
--
RGM


"CLR" wrote:

The feature you need is called Conditional Formatting. You can
access it by
doing Format ConditionalFormatting and following the menus.
You
can
invoke a base color to the cell, and 3 conditional ones. Try
it,
and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3



"mcneilr" wrote:

Folks,

I am trying to build a tracking product for training events
that
are
accomplished and those that are due. I want to have a "cell"
that
turns from
Green - Yellow - Red, based on a timeframe that I pick.
Example:
John Doe
completes yearly Egress training on 1-18-2008 that cell will
remain Green
until 3 months from his due date and then the cell will turn
Yellow. At the
date that Egress training is due again the cell will turn Red
until the
training is completed. I hope that I have not confused
anyone.
your help in
this will make my job easier to track upcoming and overdue
training.

--
RGM