| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Date Range
Excel 2003
I enter a series of dates in B3:B13 - Cells formatted as dates [ 3-Apr-10 ] I have a mini calendar in Q7:W12- Cells formatted as dates, but only showing date [ 1, 2, 3, etc. ] I would like to use Conditional Formatting to look at the range of dates in B3:B13 and highlight all the cells that contain a date in the mini calendar. I have been successful with the current date highlighting in the mini calendar with: Cell value is | equal to | =TODAY() Any help would be appreciated. Thanx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting-Date range | Excel Worksheet Functions | |||
| Date Range Conditional Formatting | Excel Worksheet Functions | |||
| Conditional formatting and Highlighting Date Range | Excel Discussion (Misc queries) | |||
| Conditional formatting and Highlighting Date Range | Excel Discussion (Misc queries) | |||
| How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
Threaded Mode
