yogi_Conditional Formatting For Dates In Column B - Compared To Reference Date red if within 7days -- yellow if within 14 days -- green if over 14 days : Sheet1