| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Date Range
Try this...
Select the range B3:B13 Select the Formula Is option Enter this formula in the box on the right: =COUNTIF($Q$7:$W$12,B3) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "BWR_Rick" wrote in message ... 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! |
| Reply |
| 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 | |||
Hybrid Mode
