VBA Code - conditional formatting
Closed
SridharK
-
16 Jul 2018 à 23:29
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Jul 2018 à 11:25
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Jul 2018 à 11:25
Related:
- VBA Code - conditional formatting
- Excel conditional formatting based on date - Guide
- Cs 1.6 code - Guide
- Vba case like - Guide
- Vba color index - Guide
- Tetris game unlock code ✓ - Android Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
17 Jul 2018 à 11:32
17 Jul 2018 à 11:32
Hi SridharK,
Why use VBA for this, but if you "must", then use the macro recorder to see how it is done.
Best regards,
Trowa
Why use VBA for this, but if you "must", then use the macro recorder to see how it is done.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
19 Jul 2018 à 11:25
19 Jul 2018 à 11:25
Hi SK,
It seems that the macro recorder doesn't record much in this case.
Give this code a try:
Best regards,
Trowa
It seems that the macro recorder doesn't record much in this case.
Give this code a try:
Sub RunMe()
For Each cell In Range("A:A")
If cell.Value <> vbNullString Then
Select Case cell.Value
Case Is < 25
cell.Interior.Color = 13551615
cell.Font.Color = -16383844
Case 26 To 35
cell.Interior.Color = 10284031
cell.Font.Color = -16751204
Case Is > 35
cell.Interior.Color = 13561798
cell.Font.Color = -16752384
End Select
End If
Next cell
End Sub
Best regards,
Trowa
