Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Conditional Formatting (more than 3) in Excel

allanabanana, on Monday September 1, 2008 12:15:26 AM
Hello,
i am trying to apply more than three options to excel that changes the background colour of the cell.

my range is R7:R1000

i need a VBA or macro that will change the background colour of the cell as follows

if cell reads "Extreme", change background to red

If Cell reads "High" change background to Purple

If Cell reads "Medium", change background to yellow

If cell reads "Low" change background to green

If cell is empty, do nothing

any assistance would be much appreciated

THANKS
Configuration: Windows XP
Internet Explorer 6.0
Reply to allanabanana  Report this message to moderators Go to last message

1


  • 1    This message seems useful, vote!
  • Ce message ne vous semble pas utile, votez !
  • Report this message to moderators
 aquarelle, on Monday September 1, 2008 03:54:18 AM
Hello,
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 "Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."
   
Reply to aquarelle
Ask your question Reply

Results for

Conditional Formatting with expiry dates Hello, I am working on a large excel spreadsheet full of training records. I have managed to use conditional formatting to highlight when a course has expired. However I am struggling to highlight when a course is due to expire within 3 months of... en.kioskea.net/forum/affich-20294-conditional-formatting-with-expiry-dates
Conditional Formatting I need to specify different text colours for certain conditions. This I can do with the conditional formatting but only for three conditions, I have tried to write some VBA code to allow me to call two or more routines to get more conditions The code... en.kioskea.net/forum/affich-26380-conditional-formatting
Conditional Format Problem Hello, I want to use Excel Conditional Format to change color of an entire row whenever there is a "cancel" placed in any of the cells in that row. All other information involves taking a value from a column entry, and not a row entry. We have daily... en.kioskea.net/forum/affich-10118-conditional-format-problem

Results for

Formatting your drive with Fat32Formatting your drive with Fat32 Windows XP normally refuse to format a partition higher than 40 GB with FAT32. however this operation performs properly with NTFS The solution for this issue is to boot your installation CD and use the... en.kioskea.net/faq/sujet-676-formatting-your-drive-with-fat32
Formatting articles of the knowledge baseFormatting articles of the knowledge base /!\Be careful /!\ : Don't do a copy/paste of a tip found on another website : First of all, it's unuseful since the same tip is twice on internet. Moreover it's possible that there's a copyright on... en.kioskea.net/faq/sujet-63-formatting-articles-of-the-knowledge-base
3wPlayer – Trojans ?3wPlayer – Trojans ? 3wPlayer is a media player who load harmful trojans on your computer once same installed on your computer. This program is designed to play in movies in ZIX format and can be freely downloaded on websites. However... en.kioskea.net/faq/sujet-438-3wplayer-a-trojans
1 2 3 Next

Results for

Conditional formatting problemsHello, I have a office 2003 instalaltion and none of the conditional formatting is working. I also created a new sheet and applied conditional formatting but the cells stays as is. No formatting is applied. en.kioskea.net/forum/affich-13623-conditional-formatting-problems
Conditionally changing row background colorHi I want to change the background color of the rows in my Excel worksheet based on the value of a certain column named 'Status'. Status can have around 7 values Conditional Formatting might not be the right choice. Following are the values... en.kioskea.net/forum/affich-27450-conditionally-changing-row-background-color
Acaddoc.lspHello, i m working in uae using autocad software, recently i found a vires effection this named "acaddoc.lsp" this vires effect only on autocad software. main effection of this software is we can't open morthan 3 file at a time becouse that time... en.kioskea.net/forum/affich-11264-acaddoc-lsp
1 2 3 Next

Results for

Download 3GP Player 2008The new mobile phones of third generation have a format of video capture particular, format 3GP. This format, computers do not take care of the most part of the formats of video capture on mobile phone. One of the resolutions that presents itself to... en.kioskea.net/telecharger/telecharger-579-3gp-player-2008
Download 3GP Converter 2008The videos which you capture on your mobile phones are in general from another format, other than those of Windows. Then to be able to read them on your computer of office, it something to convert to use a special reader. 3GP Converter is a tool... en.kioskea.net/telecharger/telecharger-570-3gp-converter-2008
Download Sweet Home 3DBefore doing up your home or your flat, it is not necessary any more to move all pieces of furniture to see result. You can consequently simulate the development of the pieces of furniture of your accommodation. Sweet Home 3D a program allowing to do... en.kioskea.net/telecharger/telecharger-752-sweet-home-3d
1 2 3 Next

Results for

Video and digital imaging - The MKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid, RV9, etc),... en.kioskea.net/video/mkv-matroska.php3
Cables and connectors - Mini-DIN connector The 4-pin Mini-DIN connector is used for transmitting analog video in S-Video format: More and more graphics cards these days have an S-Video socket built in, so that the computer's output can be viewed on a television screen. This is why it is... en.kioskea.net/elec/connecteur-prise-mini-din.php3
General Terms and Conditions of Use All Rights Reserved - 2007 - Quidéa Object These General Terms and Conditions are meant to define the ways in which the services of the website en.kioskea.net, hereafter "The Service," are made available, as well as the conditions of use of the... en.kioskea.net/ccmguide/cgu-conditions-generales.php3
1 2 3 Next