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 conditional formatting more than 3 colors
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Acer aspire 3 keyboard light - Guide
- Fnia 3 - Download - Adult games
- Excel conditional formatting if cell contains specific text - Excel Forum
16 responses
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 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.