Forum Discussion

cyberbiker's avatar
cyberbiker
Copper Contributor
Dec 19, 2018
Solved

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 a...
  • SergeiBaklan's avatar
    Dec 19, 2018

    It shall be

    =MONTH($G2)&YEAR($G2)<>MONTH(TODAY())&YEAR(TODAY())

Resources