Hi, I need help to come up with the following conditional formatting:
Color cell AB3 in red if B3 shows the word OPEN and the date on AA is -1 day, -2 days, 0 day, 1day, 2 days... 50days from today (a range from -2 days to +50 days from the current date)
Could anyone kindly help me? I quite confused trying to figure this out![]()
Bookmarks