SOLVED
Home

Conditional formatting only working correctly in column A

cyberbiker
New Contributor

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!

2 Replies
Solution

It shall be

=MONTH($G2)&YEAR($G2)<>MONTH(TODAY())&YEAR(TODAY())
THANKS!!
That did it. I knew it was something simple.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies