How to add code to =B3-C3 , So it will auto change...

Paulyeo11 · 04-10-2024 04:02 PM

Hi All

My subject title description is what I need

Cell D3 formula:-

=B3-C3

Below Link is my sheet file :-

Above image I manually change the cell black ground color to red and text to black when value is negative. I hope I can automate it.

Hope some one can advise me the code.

Paul

Rafael_ANEIC-PY

Hello there,

I don't want to sound mean, but this is an AppSheet forum, not a Google Sheets one, and I don't see any trace of AppSheet in your question.

But the answer is conditional formatting:

https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop

scott192

Here is an amazing site for all things Google Sheets. Conditional formating is described in detail on there.

How to add code to =B3-C3 , So it will auto change cell black ground color to Red & Font color to Wh