Jan 29 2020 12:46 AM
Hello everyone, im having trouble conditional formatting some dates in excel, as you can see in the screenshots, I inserted a IF function to check if the formula (between 30 and 15 days ago) is actually true, also the next one doesnt seem to work (less than 15 days ago).
Today is 29/01/2020.
Thanks to everyone for your help.
Jan 29 2020 01:15 AM
Much better if you attach sample file instead of screenshot.
In your rules not formulas, just texts, e.g
(here AND is not closed)
Jan 29 2020 01:41 AM
Jan 29 2020 01:46 AM
Jan 29 2020 03:59 AM
Jan 29 2020 04:42 AM
SolutionJan 29 2020 06:08 AM
@Sergei Baklan Thanks a lot for your help!!
Jan 29 2020 06:22 AM
Jan 29 2020 04:42 AM
SolutionI only corrected couple of misprints
Please check in attached file