Macro: change cell color based on value in another cell
randal.hite
TrowaD
- Posts
- 1
- Registration date
- Monday December 6, 2021
- Status
- Member
- Last seen
- December 6, 2021
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Excel change font color based on value
- Excel change font color based on value of another cell - Best answers
- Excel change text color based on value of another cell - Best answers
- Excel change font color based on value of another cell ✓ - Forum - Excel
- Conditional formatting change font color based on another cell ✓ - Forum - Excel
- Conditional Formatting: Font color for entire column based on another column ✓ - Forum - Excel
- Excel change text color based on value of another cell ✓ - Forum - Excel
- Changing cell background color based on another cells background - Forum - Excel
1 reply
TrowaD
Mar 3, 2022 at 11:27 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Mar 3, 2022 at 11:27 AM
Hi Randal,
Here you go:
Best regards,
Trowa
Here you go:
Sub RunMe() For Each cell In Range("E2:E" & Range("E" & Rows.Count).End(xlUp).Row) If cell.Value = "Traffic" Then Cells(cell.Row, "H").Interior.ColorIndex = 1 Next cell End Sub
Best regards,
Trowa