Tag Info

New answers tagged

2

In new Google Sheets if you select A3:Z20 and Format, Conditional formatting... and enter: =$N3<>"" for Custom formula is with a colour of your choice and Range: A3:Z20 then in the range A3:Z20 every cell should be coloured if the cell in Column N for the corresponding row is not empty. Since such formatting is conditional the IF is not ...


1

The article you reference says that custom formulae only work in the new sheets. So, have you converted your file to the new Google Sheets? (https://support.google.com/drive/answer/3544847?hl=en&ref_topic=20322)



Top 50 recent answers are included