Conditional Formatting table row based upon 1 cell value

[beckyinDC]

Hey guys- trying out conditional formatting on a table. there are about 20 columns. I want to apply simple formatting to the whole row based upon the value of 1 cell.

I can do that for a single row. my conditional formatting rule looks like:
=$H$30= "Closed"

and currently it is applied to:
=$B$30:$R$30

2 things I cant figure out:

I want to transform the formatting rule to encompass all table rows referencing their own value in that H column. So far I have only managed to get the whole table to trigger off of the same cell. Can I somehow use [ThisRow]? ...so far no luck guessing at syntax or researching it.

second concern- the table will be added to dynamically- will I need to add code to make sure the next row on the table gets the conditional formatting rule? I am hoping not, but need to consider that next if it isnt covered.

Can I do all this via the spreadsheet and conditional formatting window ...without VBA?

thanks -

Becky

 

[VoG]

Try removing a $

=$H30= "Closed"

 

[beckyinDC]

thank you!

my confusion- I was taking $ off of the H...

I found I could apply the formatting rule to the table - using the tablename - that resolved my second concern.

awesome- that resolves quite a few headaches. thanks a bunch.

 

[beckyinDC]

forgot to say- it worked like a charm- thanks again