I want to fill the background color and character color separately in the conditional format of Google spreadsheet.

I would like to fill the background color and character color separately in the conditional format of the Google spreadsheet.

Specifically, the settings like the attached image are
I'd like to change the background to blue and the letter color to red.
"The background is white, and the text color is red."

src=

google-apps-script google-spreadsheet

2022-09-30 20:19

1 Answers

It would be troublesome if something similar happened to me, but
I set all the patterns, such as the background being blue and the character color being red.
Regarding the question, is it as follows?
=AND($H9<$D9,$I9=1)

Also, Google has a function to request improvement, so

Such things should be formatted under compound conditions. I think it's better to make a request.

2022-09-30 20:19

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656