| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change colors in a range of excel cells based on another range of cells
I would like to change the color of a cell in a range (A5:D50)if any cell 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:D50 would also be compared to a second 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 *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Color a Cell Based on a Range of Cells with Colors | Excel Worksheet Functions | |||
| In excel change color of a range of cells based on a cell value | Excel Worksheet Functions | |||
| Conditional Formatting Based on Colors in a Horz Range of Cells | Excel Discussion (Misc queries) | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions | |||
Threaded Mode
