Only this =IF((F34-D34)<0;1;0) is the formula,
that
[RED]"No";[GREEN]"Yes";[RED]"No"
is a number format code you format the cell with. (and in the original not-as-code-formatted was displayed with typographic quote characters so copy-paste wouldn’t work either as intended).
1 Like