Google-sheets – Use conditional formatting to add text

conditional formattinggoogle sheets

Is it possible to use conditional formatting to edit/add text in a cell? E.g., if it matches the custom formula "=B9>A9", add "is greater than A9" as text at end of whatever is in B9. I didn't find any method to add custom formatting, all I'm seeing are colour/font formatting options.

Best Answer

Conditional formatting can only be used to change text and/or background formatting.

See: Google Support: Use conditional formatting rules in Google Sheets

Related Solutions

Google-sheets – Is it possible to add conditional formatting when number changes

This is not possible as far as I can tell. Google's conditional formatting is not very robust.

Here is Google's Conditional formatting help, although I don't think it's very helpful in your situation. It doesn't appear you can even use a cell value for the conditional formatting.

EDIT:

I found this link recently. It's much more complicated, but you can do what you want using their Javascript API.

Google Sheets – Relative Copy Conditional Formatting Referencing Other Worksheet

This does the trick:

=IF(INDIRECT("R"&ROW()&"C"&COLUMN(),FALSE)=INDIRECT("Default!R"&ROW()&"C"&COLUMN(),FALSE),TRUE,FALSE)

It's not exactly concise, but it works.

Best Answer

Related Solutions

Google-sheets – Is it possible to add conditional formatting when number changes

Google Sheets – Relative Copy Conditional Formatting Referencing Other Worksheet

Related Topic