| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Then Conditions
This is the macro I used
If Date = 1 / 1 / 4 <= 1 / 31 / 4 The Range("A1:G40").Selec Selection.Font.ColorIndex = End I If Date = 2 / 1 / 4 <= 2 / 29 / 4 The Range("A1:G40").Selec Selection.Font.ColorIndex = End I If Date = 3 / 1 / 4 <= 3 / 31 / 4 The Range("A1:G40").Selec Selection.Font.ColorIndex = End I If Date = 4 / 1 / 4 <= 4 / 30 / 4 The Range("A1:G40").Selec Selection.Font.ColorIndex = End I End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| 2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| sum on conditions..... | Excel Discussion (Misc queries) | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Threaded Mode
