Conditional Formating

[Sahuarokid]

I'm looking for help of how to set up a conditional format in a range of
cells where if a cell has a formual in it the font if colored black and if
the cell has a date input it the font is colored red

 

[Bob Greenblatt]

I'm looking for help of how to set up a conditional format in a range of
cells where if a cell has a formual in it the font if colored black and if
the cell has a date input it the font is colored red

Select the range of cells. Assuming the first cell (in the upper left corner
of the range) is A1. The go to format-conditional formatting. Choose
formula, and enter =isdate(a1) then select the formatting. However, if the
formula evaluates to a date, it will also be formatted as an entered date.
There is no easy way to distinguish whether or not a cell contains a
formula.

 

[Sahuarokid]

Bob
Thanks but that didn't give me the result I was expecting. With a date
entered (9/28/09) in cell G11 and workday formulas in the cells below G11, it
didn't differentiate the format of the cell contents. I even got a #NAME?
error in the cells below G11 when I included the conditional formatting to
the cells below G11

 

[Bob Greenblatt]

Bob
Thanks but that didn't give me the result I was expecting. With a date
entered (9/28/09) in cell G11 and workday formulas in the cells below G11, it
didn't differentiate the format of the cell contents. I even got a #NAME?
error in the cells below G11 when I included the conditional formatting to
the cells below G11

OK, then lets go step by step. First lets start with what is in the cell.
Then explain what the result you are expecting is. Then state the formulas
in the cell, the limits of your range, and what is below G11. If you get a
#NAME error, that means that the cell's formula contains an incorrect
function.

 

[Sahuarokid]

Ok
Cell g11 just contains an inputed date: 9/29/09
g12 thru g50 contains a formula that is intended to show a date for a task
to be completed based on the completion of a dependant task and the duration
or number of days it is supposed to take to complete that task:
WORKDAY(VLOOKUP(B$10:B$153,$A$1:$T$160,7,A:A),M14,$A$164:$A$189)

What I want the conditional formating to do for me is to distinguish the
dates that are presented in Column G showing those cells (ie G11) which have
an actual date written in the cell in red and those cells in column G which
are still calculated by a formula shown in black. This is meant to
distinguish actual completion dates from projected completion dates

 

[Bob Greenblatt]

Ok
Cell g11 just contains an inputed date: 9/29/09
g12 thru g50 contains a formula that is intended to show a date for a task
to be completed based on the completion of a dependant task and the duration
or number of days it is supposed to take to complete that task:
WORKDAY(VLOOKUP(B$10:B$153,$A$1:$T$160,7,A:A),M14,$A$164:$A$189)

What I want the conditional formating to do for me is to distinguish the
dates that are presented in Column G showing those cells (ie G11) which have
an actual date written in the cell in red and those cells in column G which
are still calculated by a formula shown in black. This is meant to
distinguish actual completion dates from projected completion dates

The short answer is that you can not do that. As I mentioned in an earlier
post, it is extremely difficult (without using code) to reliably determine
whether a cell contains an inputted value or a formula. Your best bet is to
use another column with an entered value to indicate whether the date in
question is estimated or actual. Then base your conditional formula on this
column.

 

[Sahuarokid]

Thanks very much for your help
--
Sahuarokid

The short answer is that you can not do that. As I mentioned in an earlier
post, it is extremely difficult (without using code) to reliably determine
whether a cell contains an inputted value or a formula. Your best bet is to
use another column with an entered value to indicate whether the date in
question is estimated or actual. Then base your conditional formula on this
column.