Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show month in different color?
I use excel at work and we have gages that are due calibration. I wanted to
know how to put in a formula or something to show each gage that is due in red at the current month. That way when the next month comes the gages due that month are in red and the other months are normal. |
#2
|
|||
|
|||
Use conditional formatting.
A1 has the date, B1 has the gage parameter / reading Select B1. Go to format conditional formatting. Select 'Formula is'. And enter in the box: =MONTH(A1)=MONTH(TODAY()) click on format button and in patterns tab select the red color. Mangesh "OneGoose" wrote in message ... I use excel at work and we have gages that are due calibration. I wanted to know how to put in a formula or something to show each gage that is due in red at the current month. That way when the next month comes the gages due that month are in red and the other months are normal. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I format a cell to show different font color after editin. | Excel Discussion (Misc queries) | |||
How do I make background color show up in my document instead of . | Excel Discussion (Misc queries) | |||
Only want color to show when cell is active | Excel Worksheet Functions | |||
The color in excel does not show up in the cell on screen | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |