| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop range change a cell color
I have a Range A10:Q85
In each row, starting in column B, some of the cells may have a text value that ends in -done , such as modelA-done or Chev-done. I would like to loop each row and if any cell has that -done value, change the cell in column A of that row to Font.color = 4 Thanks CR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell Color Dependant On Date Range | Excel Programming | |||
| By selecting a cell - change color in a range | Excel Programming | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
| change fill color of a range of cells based on color of a cell? | Excel Programming | |||
| Loop to change cell color based on found value? | Excel Programming | |||
![CR[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
