View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cyndi cyndi is offline
external usenet poster
 
Posts: 30
Default Conditional format based off of a logical if statement

hello,
I need cell H5 to turn red, if I5="y" and H5 is less than 90 days from today
date. I could get it to work for the =i5="y" but I cant seem to get the
second piece to work,(=H5-today()<91) I tired it as a second condition and
also trying to put it all as one condition. Any suggestions. I am using
Exel 03
Thanks