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

AppSheet AppSheet Q&A
1

Hi All

My subject title description is what I need

Cell D3 formula:-

=B3-C3

Below Link is my sheet file :-

https://docs.google.com/spreadsheets/d/1NOXiFQra_PQmj_RuTXZB_XzWRP2cuFNzk4i_dD7-4Hw/edit

IMG_6091.png
IMG_6091.png1170×2532 175 KB

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

2

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

3

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

https://www.benlcollins.com/