Forum Discussion
PrzemekM
Jan 07, 2025Copper Contributor
Alert in Excel charts
Hi, could you help me to correct the following formula which I try to create: =JEŻELI(G2>DZIŚ;[OK];[LATE]). Formula is in Polish version ('JEŻELI' = 'IF', 'DZIŚ' = 'TODAY'). The idea is to have an alert in column J when user points out a deadline in column G to do some actions and the deadline is missed than in column G should be communicate "LATE" and if there is still before a deadline there should be information in column G 'OK'. It would be also great if you could help me how to display a colors in column J (green = ok, red = late).
DZIŚ is a function, so you should use DZIŚ().
And text strings should be enclosed in double quotes ".
=JEŻELI(G2>DZIŚ();"OK";"LATE")
Select the range with these formulas.
I don't have a Mac, so I cannot help you with the conditional formatting.
DZIŚ is a function, so you should use DZIŚ().
And text strings should be enclosed in double quotes ".
=JEŻELI(G2>DZIŚ();"OK";"LATE")
Select the range with these formulas.
I don't have a Mac, so I cannot help you with the conditional formatting.