Thread: conditional format help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
  
Posts: 834
Default conditional format help
=A2<=C2+180

should do it

--

HTH

Bob

"hj" wrote in message
...
column A is my finished date, column C is my serial #. If I enter the same
serial # within 180 days of my finshed date what formula can I use to turn
cell red?


Reply With QuoteReply With Quote