Tag Info

New answers tagged


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 ...


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