| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flaging up an alert
Or try using Conditional Formatting:
If oyur dates were entered in column A, then select column A and open Conditional Formatting from the Format menu. with 'Formula Is' in the Conditional Format box, enter: "=IF(COUNTIF(A:A,A1)1,TRUE,FALSE)" and change the format to yellow, or whatever. Now whenever you enter a date, it will change colour if it already exists. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| alert | Excel Worksheet Functions | |||
| alert | Excel Discussion (Misc queries) | |||
| flaging items as "org","dup",etc. | Excel Worksheet Functions | |||
| Flaging Dates | Excel Worksheet Functions | |||
| Pop-up Alert Help | Excel Programming | |||
Threaded Mode
