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...