Condition for: IF TRUE then ADD 1 to A1?

[Mikey556]

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

 

[StephenCrump]

The usual approach would be to have a formula in A1 that counts the conditionally formatted cell(s) meeting the condition, like this:

	A	B	C	D	E	F	G	H	I	J
1	4
2
3
4
5
6										OverDueDays
7										7
8
9										TODAY()
10										10 Feb 2022
11
12
13
14										1 Feb 2022
15										2 Feb 2022
16										3 Feb 2022
17										3 Feb 2022
18										4 Feb 2022
19										6 Feb 2022
Sheet1

Cell Formulas
Range	Formula
A1	A1	=COUNTIF(J14:J19,"<="&TODAY()-J7)
J10	J10	=TODAY()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J14:J19	Expression	=TODAY()>=J14+J$7	text	NO

Or perhaps A1: =SomeOtherFormula+COUNTIF(J14:J19,"<="&TODAY()-J7)?