Highlighting cells within a loop
Closed
KingTut
-
May 24, 2010 at 02:33 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Highlighting cells within a loop
- It is the highlighted cell - Forum - Excel
- Vba highlight cell based on value ✓ - Forum - Programming
- Highlight cell if another cell contains text ✓ - Forum - Excel
- How to use conditional format based on text? ✓ - Forum - Excel
- Excel - Highlighting cells based on days - How-To - Excel
1 reply
rizvisa1
May 25, 2010 at 05:20 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
May 25, 2010 at 05:20 PM
Use macro record to do this. You will get the code for highlighting the rows/range
some thing like
range("A1:F1").interior.color = rgb(255,0,0)
some thing like
range("A1:F1").interior.color = rgb(255,0,0)