Hi, Please try below formula and apply conditional formatting.
=IF(COUNTIF(E4:G4,"False")=3,TRUE,FALSE) On Monday, October 4, 2021 at 8:53:47 PM UTC+5:30 [email protected] wrote: > Hi there, > I'm trying to set up some conditional formatting where the when the > "FALSE" value of a checkbox will change the background color of 3 cells in > a row. > I've got 3 columns Signed, Unsigned and Missing each set up with > checkboxes. I'd like it to be that if all three checkboxes are False the > color changes in the cells and when any checkbox is True the color goes > back to white. > =arrayformula(countif(E4:G4;false)=count(row(E4:G4))) > I had this but it wasn't working properly. > Thanks for any help! > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/f8d736c0-2ab7-4d7b-b28e-fdfe536434c8n%40googlegroups.com.
