If Formula or conditional formating

[Guest]

I am working on an employee attendance worksheet and I want that cells
change color upon cell contents, which in this case I have five conditions.
Unfrotunately in Excel 2003 there are only 3 conditions. My question is:

Can I use an IF formula to change the color of the cell according to
contents and what it is? Suppose that I want to use the letter "L" for Leave,
"P" for present, "S" for sick, "h" for holiday..etc.

Thank you for your help

 

[Guest]

You can use formulas in the conditional formatting tool. Go to
Format--Conditional formatting.

For condition 1 you want to select "formula is" and apply the appropriate
formula.

Ex: =IF(A1="L",[format red]) etc.

Dave

 

[Guest]

Hi
The if statement function cannot change the colour of a cell. Functions only
give an answer. You could however create a macro to check the values of cells
and apply color to them

Sub change_cell()
For Each cell In Selection
If LCase(cell.Value) = "p" Then cell.Interior.Color = vbRed
'copy the above line for each of your cells and list them below
Next cell
End Sub

select the cells and run the macro!

there are quicker and more complex vba code you could use. Thisis a simple,
yet effective solution