Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula or conditional formating
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 -- Microsoft Biased |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula or conditional formating
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 -- Brevity is the soul of wit. "Nora Najem" wrote: 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 -- Microsoft Biased |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula or conditional formating
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 -- Alwyas Trying Eddie "Nora Najem" wrote: 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 -- Microsoft Biased |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) |