Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting using a range | Excel Discussion (Misc queries) | |||
Conditional Formatting Range | Excel Discussion (Misc queries) | |||
Conditional Formatting In a Range | Excel Discussion (Misc queries) | |||
Conditional Formatting for a Range | Excel Discussion (Misc queries) | |||
HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE | Excel Worksheet Functions |