| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 104449 | 2009-10-28 02:10:00 | Excel auto highlight help | 041140 (15382) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 824804 | 2009-10-28 02:10:00 | hi all this is a call for help to someone who can work excel, the situation is; Ive pieced together a highlight for my job that automatically changes to highlight the correct date at midnight, the problem is that I need it to change the highlight at 7am instead of midnight to ciencide with the sceduled shifts. the conditional formatt that im using is =$a1=today help would be very, very apreciated :waughh: |
041140 (15382) | ||
| 824805 | 2009-10-28 02:14:00 | What data is in the column you're basing the conditional formatting off, a full time stamp or? | inphinity (7274) | ||
| 824806 | 2009-10-28 02:21:00 | As of now there are only dates down column A, every cell has a diffrent date.No time data yet. Im trying to figure out how to do it without having the time data visible, or having to take up any extra cells if possible. | 041140 (15382) | ||
| 824807 | 2009-10-28 03:24:00 | you could try using IF(HOUR(NOW())>6) as a check to see if it is currently 7am or later, in addition to your existing date check or whatever. | inphinity (7274) | ||
| 824808 | 2009-10-28 03:58:00 | thanx for the help I tried using that but nothing happens. When I combine it with the code it gives me an error message, I tried using it by itself to see if I was doing something wrong, but nothing happens |
041140 (15382) | ||
| 824809 | 2009-10-28 04:00:00 | also I realized I typed the code incorrectly here its actually =$A1=TODAY() | 041140 (15382) | ||
| 824810 | 2009-10-28 11:16:00 | =AND($A1=TODAY(),HOUR(NOW())>6) | fred_fish (15241) | ||
| 824811 | 2009-10-31 01:32:00 | you.....ROCK!! "fred fish" formula worked perfectly =) adapted it to my workbook thanx | 041140 (15382) | ||
| 1 | |||||