Forum Discussion

PrzemekM's avatar
PrzemekM
Copper Contributor
Jan 07, 2025

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.

Resources