Hi,
Struggling a little with two issues at the moment:
The first is I have a number of dates in Column B of a sheet (that represent the date something was created) and I am trying to make a formula that will allow me to have all the dates that are 90 days to 179 days old (from the date they were created) shade yellow and all the dates that are 180 days old and above shade red. I also need all dates that meet neither of those conditions (0 to 89 days old) to stay normal. This would obviously use the TODAY feature to constantly update based on the date.
The second issue is in Column N I need to show the date in column B plus 90 days, but if there is no information in column B, I need it to show nothing.
Any help would be appreciated, I have trawled the web for answers but making a formula to meet all those conditions is proving difficult.
Thanks
