Hello everyone!
I have a slight problem with Conditional Formatting and how it deals with text that comes after (or before) a certain date in the same cell. I have added rules that would color each Date cell by how far it is from today. I have used "Cell Value" [between =Today() & =Today() + 30 for example]. However, when I add the letter "A" in the same cell, it completely changes the value of the cell [for example: if a date is supposed be 15 days away, it should be red colored. But when I add the letter "A", it becomes blue (red = up to 30 days away, Blue = date is more than a year away)].
Excel Sample.jpg
I remember doing something that would make the cell have the correct color while still displaying the letter next to the date.
The reason I add the letter "A" is because I want to differentiate between actual & estimated dates.
Thank you for considering this.
Bookmarks