on time indicator
 

I am working on a spreadsheet where I have two dates being compared, and a
column using the If function to say whether it was completed on time or late.
I would like that field color to change depending on the outcome of the
function. Is this possible, and if so, how do I do it?

on time indicator
 

Oh, and I am using Office 2007. Sorry!

"KymiLue" wrote:

I am working on a spreadsheet where I have two dates being compared, and a
column using the If function to say whether it was completed on time or late.
I would like that field color to change depending on the outcome of the
function. Is this possible, and if so, how do I do it?

on time indicator
 

Format/ Conditional formatting
--
David Biddulph

"KymiLue" wrote in message
...
I am working on a spreadsheet where I have two dates being compared, and a
column using the If function to say whether it was completed on time or
late.
I would like that field color to change depending on the outcome of the
function. Is this possible, and if so, how do I do it?