ContributionsMost RecentMost LikesSolutionsFormula to Color A Variable CellHello All, I am trying to figure out how to color a cell based on a date range. I currently have If( [DATE]<[DATE <7days], "FF81A0", [DATE]>[DATE <7days]and [DATE]<[DATE 8-14 Days], "FFFD81", "") This functions just fine for coloring the entire row but I would like to color only the DATE cell based on the 0-7 days and 8-14 days criteria. Thanks in advance ------------------------------ Brandon Kyzer ------------------------------