I am trying to create a conditional format for when the cell has a N and the date next to it is 14 days old. I can do one or the other but not both and if I do two conditions doesn't work so trying to create one forumula for both. I'm using the formula =L1<NOW()-14 but want it to only change the color if the cell also equals N, any help would be appreciated
Bookmarks