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. |
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. |
All times are GMT +1. The time now is 11:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com