Thread: conditional formatting based on a different cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Picodillo Picodillo is offline
external usenet poster
  
Posts: 3
Default conditional formatting based on a different cell
In column A I have "Date Started" dates. In Column B I have "Date Completed"
Dates. I have conditional formatting already set up to highlight column A
red if it is more than 7 days old, but I want to make a condition for Column
A to be green if there is anything entered in column B.
Reply With QuoteReply With Quote