| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
I would like to change the color of a cell in a range (A5  50)if anycell equals any cell in another range (V9:V20). All ranges are dates and V9:V20 are not necessarily consecutive dates. In addition that same set of cells A5 50 would also be compared to asecond set of dates (V30:V35) and if any cell equals any date in this second range. If so, the cell would change to a different color. Any ideas? Thanks, Bobbi *** Sent via Developersdex http://www.developersdex.com *** |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Bobbi
Try apply these two formula to conditional formattin =SUMPRODUCT(--(A5=$V$30:$V$35))>0 (set red colour) and =SUMPRODUCT(--(A5=$V$9:$V$20))>0 (set blue colour) to cell A5. Then copy the cell A5 and paste special, format to other cell A5 50Lee Li Fon Blog: http://smartusemicrosoftoffice.blogspot.com/ --- frmsrcurl: http://msgroups.net/microsoft.public...n-another-rang |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Color a Cell Based on a Range of Cells with Colors | ron weasley | Microsoft Excel Worksheet Functions | 1 | 13th Jan 2010 01:05 AM |
| In excel change color of a range of cells based on a cell value | kwitt | Microsoft Excel Worksheet Functions | 1 | 18th Nov 2009 07:20 PM |
| Conditional Formatting Based on Colors in a Horz Range of Cells | DOUG ECKERT | Microsoft Excel Misc | 10 | 19th Dec 2008 02:29 PM |
| how to compute a range of cells based on another range of cells? | =?Utf-8?B?SEFST0xE?= | Microsoft Excel Worksheet Functions | 1 | 30th Dec 2005 09:32 PM |
| how to compute a range of cells based on another range of cells? | =?Utf-8?B?SEFST0xE?= | Microsoft Excel Worksheet Functions | 2 | 30th Dec 2005 07:55 PM |
