Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the Status of Cell
A B C D
1 Badge # End Date Exp. Date Status 2 621355 12/10/06 12/09/08 Expired 3 621342 02/21/10 02/21/12 Valid 4 621543 06/07/10 5 621549 XXX XXX First You helped me alot, thank you for that; 1-How can I make Cell (D4), identify wich employee is Expired (C2), or Valid (C3), or Enrolled (C4), or N/A (C5). 2-The result in Column (D) will be copyed into another sheet, but Can I make the Cell Color Change based on the Status. For Examployee if the Stauts is Expired, the color of the Cell will change into RED, and if the Status is Valid the color will change into Green,,,ETC. I know that it's hard to do it, but EXCEL is rich and everything can be done using it. This data I am doing it is requested by management and belong to 4000 Employee X 4 Category = ,,,?. It's hard work, please help me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the Status of Cell
hi,
use conditional formating, highlight cell, text contains, enter expired, choose color red, do the same again with the others options "Khalid A. Al-Otaibi" wrote: A B C D 1 Badge # End Date Exp. Date Status 2 621355 12/10/06 12/09/08 Expired 3 621342 02/21/10 02/21/12 Valid 4 621543 06/07/10 5 621549 XXX XXX First You helped me alot, thank you for that; 1-How can I make Cell (D4), identify wich employee is Expired (C2), or Valid (C3), or Enrolled (C4), or N/A (C5). 2-The result in Column (D) will be copyed into another sheet, but Can I make the Cell Color Change based on the Status. For Examployee if the Stauts is Expired, the color of the Cell will change into RED, and if the Status is Valid the color will change into Green,,,ETC. I know that it's hard to do it, but EXCEL is rich and everything can be done using it. This data I am doing it is requested by management and belong to 4000 Employee X 4 Category = ,,,?. It's hard work, please help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
reuest formula for auto update status & status date | Excel Worksheet Functions | |||
Display worksheet protection status in a cell? | Excel Worksheet Functions | |||
Lock Cell status | Excel Discussion (Misc queries) | |||
How do I retain blank cell status in an IF statement? | Charts and Charting in Excel |