Evening all!
In 'Conditional Formats' > 'Use a formula to determine which cells to format' I used the below condition to turn a cell green when my conditions were met, successfully:
=IF(TODAY()>=J14+J$7, TRUE())
I want the exact same condition, but for it to ADD 1 to a different cell.
How would I make that condition add +1 to cell A1 for example?
Thank you all for your time
In 'Conditional Formats' > 'Use a formula to determine which cells to format' I used the below condition to turn a cell green when my conditions were met, successfully:
=IF(TODAY()>=J14+J$7, TRUE())
I want the exact same condition, but for it to ADD 1 to a different cell.
How would I make that condition add +1 to cell A1 for example?
Thank you all for your time
