LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting using a range Marc's NYK Excel Discussion (Misc queries) 1 August 14th 09 04:00 PM
Conditional Formatting Range Jean Excel Discussion (Misc queries) 5 November 29th 07 11:27 PM
Conditional Formatting In a Range mikesteven Excel Discussion (Misc queries) 1 July 13th 06 09:37 PM
Conditional Formatting for a Range ahishaslauer Excel Discussion (Misc queries) 2 April 3rd 06 02:29 AM
HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE PeggyP Excel Worksheet Functions 2 November 4th 04 07:29 PM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"