Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a formula to AUTOMATICALLY highlight a specific month
I have an Excel spreadsheet and in it I enter dates (creating ledgers). We
highlight (manually) each line of data containing the March balances. I'd love to use conditional formatting to do this for me, but can't figure out how. The only thing I want it to be able to do is highlight (pattern=yellow) any and every cell that contains the month march (it will only be entered as a date code, so month=3). Thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight the cell date of current month | Excel Discussion (Misc queries) | |||
Highlight automatically a specific cell | Excel Worksheet Functions | |||
Formula to count month-specific items | Excel Discussion (Misc queries) | |||
formula to highlight specific numbers | Excel Discussion (Misc queries) | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions |