View Single Post
  #1   Report Post  
Keyrookie Keyrookie is offline
Member
 
Posts: 84
Default 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