Forum Discussion
Conditional formatting only working correctly in column A
I have a small spreadsheet that I am using as a test bed for a final one that will come later. 136 rows, A-G on columns. Row 1 is a header.
Columns A-F are formatted as text, column G is formatted as a short date. The data represents planned maintenance work orders that have been created and still open, with the date in column G representing the creation date. What I am trying to do is to have it bold the entire row if the creation date is NOT the current month.
What I have currently is only working properly in column A, but is bolding everything in all of the other columns and I can't figure it out. Probably something simple that I am just not seeing.
The parameters of the conditional formatting that isn't quite working correctly are as follows:
Selection shows as $A$2:$G$136
Formula is =MONTH(G2)&YEAR(G2)<>MONTH(TODAY())&YEAR(TODAY())
I just can't figure out why it is bolding only the correct cells in column A but bolding everything else in the spreadsheet.
Thanks for any guidance on this issue!
It shall be
=MONTH($G2)&YEAR($G2)<>MONTH(TODAY())&YEAR(TODAY())
It shall be
=MONTH($G2)&YEAR($G2)<>MONTH(TODAY())&YEAR(TODAY())
- cyberbikerCopper ContributorTHANKS!!
That did it. I knew it was something simple.