| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting and cloring cells and date calculations
I want to calculate time passed by subtracting one date from another and put
the time in hours and minutes in a cell. If the value in the cell is greater than a value in another cell, then I want to turn the first cell red. If it is equal to or less, then turn the cell green. A1 B1 C1 D1 Date Date Subtract A1 from B2 and If C1 greater than D1, put answer in C1 in hours and minutes make C1 Red. If not Make C1 Green |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Difficulties with date in conditional calculations | Excel Worksheet Functions | |||
| Conditional Formatting - due date | Excel Worksheet Functions | |||
| re auto cloring of cells | Excel Worksheet Functions | |||
Threaded Mode
