2
votes

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.

1

1 Answers

1
votes

Unfortunately, conditional formatting is not able to imprint any kind of text/numeric values.

The only way how to do so is pasting =IF(E25<C25, "do something", ) in F26. If you want to avoid formula per row, you will need to use ARRAYFORMULA() variance.