Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change Cell Color if in current Month
I have months written in the top row (i.e. Jan., Feb. Mar. Apr...etc.) If I
am in the current month I want the month's cell color to turn yellow and the text to be black, if not in the current month, I want the cell color black and text white. Any ideas appreciated. Thanks. |
#2
|
|||
|
|||
Hi Leslie
Use CF http://www.contextures.com/xlCondFormat01.html If you need more help post back -- Regards Ron de Bruin http://www.rondebruin.nl "Leslie" wrote in message ... I have months written in the top row (i.e. Jan., Feb. Mar. Apr...etc.) If I am in the current month I want the month's cell color to turn yellow and the text to be black, if not in the current month, I want the cell color black and text white. Any ideas appreciated. Thanks. |
#3
|
|||
|
|||
I'd be inclined to put the current month as part of the title, then do
conditional formatting to cjange the colour of the cell. "Leslie" wrote: I have months written in the top row (i.e. Jan., Feb. Mar. Apr...etc.) If I am in the current month I want the month's cell color to turn yellow and the text to be black, if not in the current month, I want the cell color black and text white. Any ideas appreciated. Thanks. |
#4
|
|||
|
|||
I put the date in one cell, A3 and formated it just showing the month and
then did a conditional format that was =A3-Jun and it didn't work. I'm new to this, can you tell me how I need to enter my condition. Thanks. "Becky" wrote: I'd be inclined to put the current month as part of the title, then do conditional formatting to cjange the colour of the cell. "Leslie" wrote: I have months written in the top row (i.e. Jan., Feb. Mar. Apr...etc.) If I am in the current month I want the month's cell color to turn yellow and the text to be black, if not in the current month, I want the cell color black and text white. Any ideas appreciated. Thanks. |
#5
|
|||
|
|||
Select entire range In format conditional formats - Formula is dropdown =TEXT(NOW(),"MMM") = A$1 set your patterns and fonts where A1 = Jan =TEXT(NOW(),"MMM") creates the string "Jun" as now() is Jun A$1 will set the conditions in column A to change if the value in A1 = todays month Column F will properly refer to F$1 and produce the pattern because F1 would be Jun Lance "Leslie" wrote: I put the date in one cell, A3 and formated it just showing the month and then did a conditional format that was =A3-Jun and it didn't work. I'm new to this, can you tell me how I need to enter my condition. Thanks. "Becky" wrote: I'd be inclined to put the current month as part of the title, then do conditional formatting to cjange the colour of the cell. "Leslie" wrote: I have months written in the top row (i.e. Jan., Feb. Mar. Apr...etc.) If I am in the current month I want the month's cell color to turn yellow and the text to be black, if not in the current month, I want the cell color black and text white. Any ideas appreciated. Thanks. |
#6
|
|||
|
|||
Thanks very much. What would the formula look like to say the Month DOES NOT
equal the date. I'd like this as a second condition so I can make it a different color. "LanceB" wrote: Select entire range In format conditional formats - Formula is dropdown =TEXT(NOW(),"MMM") = A$1 set your patterns and fonts where A1 = Jan =TEXT(NOW(),"MMM") creates the string "Jun" as now() is Jun A$1 will set the conditions in column A to change if the value in A1 = todays month Column F will properly refer to F$1 and produce the pattern because F1 would be Jun Lance "Leslie" wrote: I put the date in one cell, A3 and formated it just showing the month and then did a conditional format that was =A3-Jun and it didn't work. I'm new to this, can you tell me how I need to enter my condition. Thanks. "Becky" wrote: I'd be inclined to put the current month as part of the title, then do conditional formatting to cjange the colour of the cell. "Leslie" wrote: I have months written in the top row (i.e. Jan., Feb. Mar. Apr...etc.) If I am in the current month I want the month's cell color to turn yellow and the text to be black, if not in the current month, I want the cell color black and text white. Any ideas appreciated. Thanks. |
#7
|
|||
|
|||
Lance, I tried it but I couldn't get it to work. In A1 I have =Now()
formatted as Jun. Am I doing something wrong. Thanks. "LanceB" wrote: Select entire range In format conditional formats - Formula is dropdown =TEXT(NOW(),"MMM") = A$1 set your patterns and fonts where A1 = Jan =TEXT(NOW(),"MMM") creates the string "Jun" as now() is Jun A$1 will set the conditions in column A to change if the value in A1 = todays month Column F will properly refer to F$1 and produce the pattern because F1 would be Jun Lance "Leslie" wrote: I put the date in one cell, A3 and formated it just showing the month and then did a conditional format that was =A3-Jun and it didn't work. I'm new to this, can you tell me how I need to enter my condition. Thanks. "Becky" wrote: I'd be inclined to put the current month as part of the title, then do conditional formatting to cjange the colour of the cell. "Leslie" wrote: I have months written in the top row (i.e. Jan., Feb. Mar. Apr...etc.) If I am in the current month I want the month's cell color to turn yellow and the text to be black, if not in the current month, I want the cell color black and text white. Any ideas appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move the current cell to the top of the screen? | Excel Discussion (Misc queries) | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
Current Month Query | Excel Worksheet Functions |