changing color of a cell based on logical return

[thexfactor44]

I need to change the text color in a given cell if it contains yesterday's date. The date is entered in the following format (if it matters):
4/15/02 (for example)
After the next day, all the previous cells that were yesterday's date will be two days ago and I need them to go back to normal black...and the new dates that qualify as yesterday should highlight text. What can I do?

thanks for all responses.

[IML]

Highlight your range and se conditional formatting under the format menu.

set condition one to cell value is equal to and then type in =today()-1. Then select whatever format you want to apply to yesterday's date.

[Aladin Akyurek]

On 2002-05-02 13:45, thexfactor44 wrote:
I need to change the text color in a given cell if it contains yesterday's date. The date is entered in the following format (if it matters):
4/15/02 (for example)
After the next day, all the previous cells that were yesterday's date will be two days ago and I need them to go back to normal black...and the new dates that qualify as yesterday should highlight text. What can I do?

thanks for all responses.

Select relevant range of dates and apply conditional formatting with Formula is where you enter:

=TODAY()-E1=1

and select a format.

E1 is the first cell of the range. Adjust to suit.

[s-o-s]

On 2002-05-02 13:45, thexfactor44 wrote:
I need to change the text color in a given cell if it contains yesterday's date. The date is entered in the following format (if it matters):
4/15/02 (for example)
After the next day, all the previous cells that were yesterday's date will be two days ago and I need them to go back to normal black...and the new dates that qualify as yesterday should highlight text. What can I do?

thanks for all responses.

Lets assume column A holds the dates in your spreadsheet and Cell A1 holds todays date.

Lets say the Text is in Column B and you want to put on a Red fort to yesterdays Text.

select the whole Column B

Call up Format - Conditional Formating

Change 1st box in Condtion 1 to Formula is

In 2nd box enter the formula

=A1=$A$1-1

Click format button change font to bold and red

click OK

That should do the trick


Hope This Helps

[thexfactor44]

THANKS! you helped again...quite a good think tank gathering over here..I appreciate it!