hi,
Formulas return a value, they can not perform an action. like change the
color of a cell.
but you an use conditional formating to do that.
Format>Conditional formating
cell value is Equal to ="yes"
Format button>pattern tab>some color
OK
as to your formula, yes, you can change the text.
=if(TODAY()-D11>=60,"Yes","No")
just be sure that the text you want displayed is inclosed in double quotes.
"Text"
regards
FSt1
"John" wrote:
> Hi.
>
> Today I made a formula for calculating if the date in a column is
> older than 60 days or not.
>
> This is the formula:
>
> =IF(TODAY()-D11>=60,TRUE,FALSE)
>
> If I want all the ones that are True for the rows to be turned a
> different colour how can I do this part?
>
> And as far as the true and false part goes, does it always have to be
> these words? Is it possible to get the formula to display other words
> instead like a YES or a NO? When I type over the true and false to
> change them to a yes and no, it comes up with an error, so I believe
> these words are a vital part of the VB code?
>
> Thanks for your help
>
> John
>
>
>
Bookmarks