| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Used as a Time Sheet
Hi, Emmana-
Your conditional formatting formula in A11 is =AND(A11="",E11="") Note that there is no consideration of a date, since from your description it sounds like each sheet represents a single day. Your conditional formatting formula in D11 is =AND(D11="",E11="") Your conditional formatting formula in E11 is =AND(E11="",AND(A11="",D11="")) You can copy those cells into the rest of your range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Time Sheet - Rounding To Quarter Hours | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Threaded Mode
