Conditional Formatting: using formula to highlight row

[Rana Gray]

Hello All!

I have my Table (Table13) I want the respective row to highlight when an "x" is in column D ("Reviewed (x)")

This is the formula I'm using in conditional formatting: =$D$5="x" | applied to =$D$5:$I$5

which does of course work, however the problem I'm having is because it is a fixed reference I am unable to copy the formatting down throughout the table without editing each row formula. How can I fix this without taking a ridiculously long time?

Thanks a bunch in advance!!!!

 

[Joe4]

Select the entire range that you want to apply this Conditional Formatting to (D5:I40), and then change your formula to the following in order to allow the row number to change (as we only want to lock the column reference, not the row reference):

=$D5="x"

 

[Rana Gray]

Select the entire range that you want to apply this Conditional Formatting to (D5:I40), and then change your formula to the following in order to allow the row number to change (as we only want to lock the column reference, not the row reference):

=$D5="x"

You are my actual favourite - such a simple solution thank you!!!!

 

[Joe4]

You are welcome.

Yes, it is easy, once you know all the "tricks"!