Why not combine the condition as:
AND(D1<TODAY()-90,F1<"")
and copy down


"Sheeloo" wrote:

Select Col D (if you want to highlight Col D based on Col F)
Choose Formula is
Enter the formula as
=F1<""
if D1 is the first cell you have selected.

This will be true whenever F has a value in corresponding row.

Have this as the first condition.

If you want to highlight the whole row, then select multiple columns and
enter the condition as
=$F1<""

"Pattee" wrote:

I know but I can not get it to work... It doesn't recognize that I have
anything in G... Maybe I am not setting it up right... so I would have the
one (column D) ="TODAY()-90" be the second condition but how would I set up
the second one that states column D doesn't turn red text is entered in
column F?

"Sheeloo" wrote:

In Excel 2003 you can have upto three conditions and the first one which is
found to be true is applied to the cell.



"Pattee" wrote:

Column D is formated as follows ="TODAY()-90" so that if it is over 90 days
past due the font will turn red... but I am trying to format it so that if I
have text entered into column F it stays black as the format doesn't apply...