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 |
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 |
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 |
All times are GMT +1. The time now is 09:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com