Google-sheets – Google Sheets Conditional Formatting Formula

conditional formattingformulasgoogle sheets

I am doing a formula in conditional formatting and I need it to be relative to each of the 1500 rows but it keeps retrieving an absolute value. how do I get around putting a new formatting formula for each row?
this is my formula:

=AND(G5<I2,ISBLANK(H5)=True)

need it to be applied, relatively, to E5:E1500.

Best Answer

=AND(G5 < I$2, ISBLANK(H5))

=AND(G5 < I$2, ISBLANK(H5), LEN(G5))

Related Solutions

Google Sheets – Conditional Formatting Based on Multiple Fields

FORMULAS:

RED:

=if(And(COUNTA(B42:H42)>1,isblank(D42)),true,false)

YELLOW

=if(and(istext(D42),(Or(isblank(B42),isblank(C42),isblank(E42),isblank(F42),isblank(H42)))),true,false)

GREEN

=if(counta(B42:H42)=7,true,false)

Google Sheets – How to Lock or Protect Conditional Formatting

I'm afraid that currently it's not possible to use cut & paste / drag & drop. Consider to send a feature request directly to Google through Google Feedback: Click on menu Help > Report a problem.

An alternative to using Cut and Paste is to use Insert Cells > Shift down

Select E14:G14
Right clic over the selected range
Click on Insert Cells > Shift down

NOTE: Keyboard shortcut for Spanish Latinamerican layout Ctrl++ with override Chrome shorcuts enabled.

Best Answer

Related Solutions

Google Sheets – Conditional Formatting Based on Multiple Fields

Google Sheets – How to Lock or Protect Conditional Formatting

Related Topic