Are you stuck on Excel or Google Sheets?

I need a conditional formatting formula to change the color and text of a cell in row 2 based on a numerical value in row 1.

Conditional formatting - I'm trying to change the format of a cell based on the value in another cell. I have a table with 100+ lines; when column E reads "complete," I want column C to go back to plain format

Formula help: =COUNTBLANK(offset(Inglewood!C$2,,MATCH(D3,Inglewood!$C$1:$N$1,0)-1,counta(Inglewood!$A:$A)-1)) This is helping me have conditional formatting based on empty cells from another tab. I want to change the range of data that is being seen. (i.e. instead of C2:C47 I want it to be C11:C47)

I need help with conditional formatting. I would like to highlight cells based on a "yes/no" value rather than numeric digits.