Fill Cells

[MMCC67]

Hi All,

First time poster here, but I think it'll not be my last!!

How do you change the fill colour of a cell depending on the cells entry?

For example, if the cell is a pass I want to type the letter P and the cell to be highlighted in green and if it's a fail I want to type the letter f and want the cell to be highlighted in red.

I tried to do this using an IF formula, but this creates a circular reference. Is this the way it has to be done, or is there an easier alternative?

I've always thought I was half decent with Excel - obviously not!!

Any help would be appreciated.

 

[cummingsea]

you can do this using Conditional Formatting
Select Conditional Format, select new rule,select cell only cell that contain in the first box select TEXT, 2nd box containing, 3rd box type the letter you want then click on format button ans set color click ok
If you have Excel 2007 you can set up a color for every letter you want, but if you have 2002 or 2003 you are limited to 3 colors or you will have to use VBA for more then 3

 

[VoG]

One way is conditional formatting - see http://www.contextures.com/xlCondFormat01.html

Another is to use an event procedure - right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case UCase(Target.Value)
    Case "P"
        Target.Interior.ColorIndex = 4
    Case "F"
        Target.Interior.ColorIndex = 3
    Case Else
        Target.Interior.ColorIndex = xlNone
End Select
End Sub

then close the code window.

 

[Datsmart]

Take a look at this demo:
http://www.datapigtechnologies.com/flashfiles/conditionalformatexcel.html