Conditionally formatting a cell based on another cell's value in Google Spreadsheet

Question

I did some searching on this and came across this post

However, this solution uses an onEdit() trigger. I would like to see a solution that uses a formula approach, so in the OP's example from that post, the formula would be like so:

=setcolor( if(A1=1,true,false), RGB(255,255,0) )

How can I create a formula that does this? Thanks in advance.

Answer 1

This may help you: Google spreadsheets conditional formatting

How to enter your Apps Script into your spreadsheet: http://code.google.com/intl/de/googleapps/appsscript/guide.html

Answer 2

It is not possible to use formulas for conditional formatting based on this Google Groups Discussion.