Conditional Formatting In Tables

[Joe Shaer]

Hello -

I have a table with each row containing a conditional format.

Under the 'status' column, if the cell is set to 'pending' - the entire row turns into red text. If this cell is set to 'complete' the entire row turns into black text.

However, when I expand the table to create a new a row, the conditional format doesn't work in this new row.

I want to be able for the table to expand (create a new row) with the conditional formatting applying into that row. It doesn't seem to do this. Can someone help?

I am attaching a sample file.

 

[ETAF]

you have $ against the row in conditional formatting formula
change that to
$B3="pending"

 

[Joe Shaer]

you have $ against the row in conditional formatting formula
change that to
$B3="pending"

Thanks a bunch! Can't believe I missed this

 

[ETAF]

you are welcome
no problem
I did the same today , with a question i have on anther forum today and th esolution when i copied into the real sheet - i kept applying
ROW($A$1)
instead of ROW($A1)
stopped it working ......

 

[Martyn Pattison]

Hi struggling to get something similar working when using with Tables. In attached example I am wanting to highlight full row green, where column N shows Completed. Started by entering formula in cell E8, but failing to get it to change Any pointers would be welcome. Many thanks

 

[ETAF]

probably better starting a new thread - as this one may not get the same members responding
probably need a $ in the formatting - i will look

select the table E8:N1000 - or however many rows likely to use in future
and then use
=$N8="completed"

if that has not worked , as i say - start a NEW thread

 

[Martyn Pattison]

Appreciate the quick feedback! Works great....

 

[ETAF]

you are welcome