If checkbox is no/false highlight row?

..... So QuickBase IF formulas are in fact much easier than Excel formulas as you can stack them vertically for readability and you can just list your conditions all in one if statement. It will evaluate the conditions in the order they are listed and take the first one which is true.  

IF(

[Confirmed Sent]=false, "#ffff88",

Contains([invoice status], "reverse", "#A9A9A9"), 

Contains([invoice status], "duplicate", "#A9A9A9")

You have to decide what sequence to do the testing because once it gets coloured yellow in the first line it will never have a chance to be coloured gray so you have to decide which is more important.  

Laura Thacker another Quickbase developer has a nice app here with all the row colours. https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000006&dr=1  but also many of the rainbow color names work like red or pink or yellow or blue ...

If([Confirmed Sent]=false or [Invoice Status]="Reverse" or [Invoice Status]="Duplicate Invoice (created in error)" or [Invoice Status]="Invoice Reversed", "#ffff88")

That combines them all to do the same color, you could do different conditions if you wanted a different color though.

If(

[Confirmed Sent]=false, "#ffff88",

[Invoice Status]="Reverse" or [Invoice Status]="Duplicate Invoice (created in error)" or [Invoice Status]="Invoice Reversed","some other color"

)

------------------------------
Chayce Duncan
------------------------------