| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Color based upon value on another worksheet
I need help cell coloring based upon matching data on 2 sheets.
'Sheet1' - Data Dump 'Sheet2' - New Formatting 'Sheet1' column AD = "No" then find value on same row but in Column B Then search on 'Sheet2' for that value in Column B. If found, color the field in the row above it Red (Color.Index = 3) I need to check each row of column AD on 'Sheet1' for value = "No" and search all fields on 'Sheet2' for the value in Column B of same row. The colored cell on 'Sheet2' will always in the the same column but 1 row up. Thank you for any assistance you can provide. Dwayne P. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the color of a cell in excel based on due date | Excel Worksheet Functions | |||
| Changing Cell Color Based on Value | Excel Worksheet Functions | |||
| Changing font color based on type cell it is. How to do it? | Excel Programming | |||
| Changing background color based on different cell | Excel Discussion (Misc queries) | |||
| Changing cell color based on its value | Excel Programming | |||
Threaded Mode
