DALE1612
New member
- Joined
- Sep 22, 2015
- Messages
- 18
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2007
Hell o guys, I am having trouble with setting conditional formatting that falls between two dates. I dont need to see a red cell at A2, and I do need to see red cells at A11,12 according to the the dates set out in "C" & "D"
I have had add a minus 1 to the formula to hightlight the cells that fall between the dates other wise the column goes red and leaves the other cells without any fill. which is the reverse of what is required. I am not sure if this is the correct way to set the formula out or not? the formula seems to be straight forward but this is a bit baffleing. I att a srceen print to show what is happening. Any would be appreciated.
Thank you.
I have had add a minus 1 to the formula to hightlight the cells that fall between the dates other wise the column goes red and leaves the other cells without any fill. which is the reverse of what is required. I am not sure if this is the correct way to set the formula out or not? the formula seems to be straight forward but this is a bit baffleing. I att a srceen print to show what is happening. Any would be appreciated.
Thank you.