Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting based upon array
Lets say there is a calendar that has a1 = 1/1/2006 and a2=a1+1, etc. Now then, lets say you have an array of dates somewhere else and want to change the background color of a1 if its date appears in the array. How can I do that? I have tried if($z$1:$z$10=a1,1,0) and it will only work on the first date, z2's date doesn't change color. Frequency does the same thing. John -- RocketMan ------------------------------------------------------------------------ RocketMan's Profile: http://www.excelforum.com/member.php...o&userid=34491 View this thread: http://www.excelforum.com/showthread...hreadid=542553 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting based upon array
=ISNUMBER(MATCH(A1,$Z$1:$Z$10,0))
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "RocketMan" wrote in message ... Lets say there is a calendar that has a1 = 1/1/2006 and a2=a1+1, etc. Now then, lets say you have an array of dates somewhere else and want to change the background color of a1 if its date appears in the array. How can I do that? I have tried if($z$1:$z$10=a1,1,0) and it will only work on the first date, z2's date doesn't change color. Frequency does the same thing. John -- RocketMan ------------------------------------------------------------------------ RocketMan's Profile: http://www.excelforum.com/member.php...o&userid=34491 View this thread: http://www.excelforum.com/showthread...hreadid=542553 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on Upper case | Excel Worksheet Functions | |||
Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting across a row, based on value in a single ce | Excel Discussion (Misc queries) | |||
Conditional formatting based on if statement. | Excel Worksheet Functions |