Conditional Formatting Formulas Not Working? - Automate Excel
https://www.automateexcel.com/conditional-formatting/formulas-not-working
WEBJul 9, 2022 · The formula (using the IF Function) to do that is simple: =IF(E4="Overdue", TRUE, FALSE) However, if you apply this to the conditional formatting, it returns the following. Only the first column in the range is formatted. Now try this formula in your worksheet. You get the desired result: TRUE for when the Project is Overdue in Column E.
DA: 10 PA: 62 MOZ Rank: 43