Conditional Formatting (more than 3) in Excel
Solved/Closed
allanabanana
Posts
2
Registration date
Sunday August 31, 2008
Status
Member
Last seen
August 31, 2008
-
Aug 31, 2008 at 07:15 PM
Waynef - Nov 14, 2010 at 10:03 PM
Waynef - Nov 14, 2010 at 10:03 PM
Related:
- Excel 4 color scale
- 4 elements trainer - Download - Adult games
- Diablo 4 free download - Download - Role playing
- Pluraleyes 4 download - Download - Video editing
- Gta 4 download apk pc - Download - Action and adventure
- Left 4 dead 2 download - Download - Shooters
16 responses
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Aug 31, 2008 at 10:54 PM
Aug 31, 2008 at 10:54 PM
Hello,
Try with this macro, you have to write in Visual Basic Editor :
Hope this is what you want.
Best regards
Try with this macro, you have to write in Visual Basic Editor :
Private Sub Worksheet_Change(ByVal Target As Range) Set MyPlage = Range("R7:R1000") For Each Cell In MyPlage If Cell.Value = "Extreme" Then Cell.Interior.ColorIndex = 3 End If If Cell.Value = "Hight" Then Cell.Interior.ColorIndex = 4 End If If Cell.Value = "Medium" Then Cell.Interior.ColorIndex = 18 End If If Cell.Value = "Low" Then Cell.Interior.ColorIndex = 6 End If If Cell.Value <> "Extreme" And Cell.Value <> "Hight" And Cell.Value <> "Medium" And Cell.Value <> "Low" Then Cell.Interior.ColorIndex = xlNone End If Next End Sub
Hope this is what you want.
Best regards
Dec 19, 2008 at 09:47 AM
Jan 14, 2009 at 10:15 AM
Thanks for the help.