In Google Sheets I'm trying to add text to a different cell with a conditional formatting formula acting upon two other cells.
For example, I have a couple of columns... 'C' and 'E'. I'm comparing the values in C25 and E25, like so: =E25<C25
. That works, I can change a cell to red using that formula.
But what if I want to put a formula in cell F26 to print some text???
I tried this in F26: Format | Conditional formatting... | Apply to range: F26 | select Custom formula is... | and typed: =IF(E25<C25, "do something", "")
When E25 is less than C25, I don't see "do something" appear in E26. Thanks in advance for any assistance.