Conditional Formatting with range
Help please,
I have a column of dates that I want to format if they match another column of dates.
Ex. AF251:AF255 = T249:T275
In other words, if any of the dates in cells AF251:AF255 match the dates in cells T249:T275 I want the format to change. So far all I have is this:
=AND($T$249:$T$259)
but every cell from AF251:AF255 reformats. I want only the cells with matching dates to reformat.
Thanks in advance,
K
|