conditional format with cell and wildcard

[rjmdc]

hi
how would i conditionally format fill an entire row if column E contains "partial"
same if column J contains "deductions"

 

[etaf]

yes

 

[rjmdc]

table is now a2 till AF 900+
it grows every day

 

[etaf]

then select a larger number of rows
Say 3000
so A2 to AF3000

BUT you could select just the columns A to AF
But its very inefficient and may slow the spreadsheet down depending on what else is being calculated
if you do choose A:AF
then you need to change the formulas to use row 1 and not 2

so $E2 becomes $E1 and all other cells with a 2 change to a 1

 

[rjmdc]

i will try this and report

 

[etaf]

ok, any issue please come back, perhaps use XL2BB to post a sample - see signature or put on a share , like onedrive or dropbox, i tend not to got to unknown random shares