| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop to change cell color based on found value?
Hello there,
I'm trying to find a value in column "B16","B46" and based on that value set the upper limits to the cells in that row starting at column E to the end (last column) I need to match certain conditions after finding the desired value. The Colored cells begin on column E, the same for the values to be checked and colored orange I've been trying to use ActiveCell.Offset but I can only go through rows or through columns, not both. i.e. If "P" And Cell.Interior.ColorIndex = 6 And Cell.value 5000 ActiveCell.Interior.ColorIndex = 44 If "Na" or "Mg" or "K" And Cell.Interior.ColorIndex = 6 And Cell.value 5500 ActiveCell.Interior.ColorIndex = 44 If (Rest of cells) And Cell.Interior.ColorIndex = 6 And Cell.value 500 ActiveCell.Interior.ColorIndex = 44 Any help will be more than appreciated. Right now I'm "looping" and confusing myself with the best approach -- Gaba |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Can a cell change color based on the value of another? | Excel Discussion (Misc queries) | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Change tab color based on a cell value | Excel Discussion (Misc queries) | |||
Threaded Mode
