Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Sheets, Invalid Formula: Need fix for Conditional Formatting?

When I paste =and(V26<0,Settings!C14=TRUE) in a cell, it evaluates correctly, to TRUE.

When I enter the same formula in Custom Formula I get an error as shown.

How can I correct this please?

enter image description here

like image 520
James Raitsev Avatar asked Dec 20 '25 20:12

James Raitsev


1 Answers

It seems that Indirect is a way to go

=and(V26<0,INDIRECT("Settings!C14")=TRUE)

works

like image 99
James Raitsev Avatar answered Dec 24 '25 12:12

James Raitsev



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!