Color Coding Problem in Excel 2007 - MrExcel Message Board

		MrExcel Message Board > Question Forums > Excel Questions
Color Coding Problem in Excel 2007

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

Nov 8th, 2009, 12:31 AM

threepick

Join Date: Sep 2009

Posts: 10

Re: Color Coding Problem in Excel 2007

Quote:

Originally Posted by Andrew Poulsom

You can use a fomula like:

=MONTH(K$1)=MONTH(TODAY())

The $ sign before the 1 fixes the row reference.

This works as described.

Bookmarks

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Forum Rules

All times are GMT +1. The time now is 11:20 AM.