Conditional Formatting

[Guest]

If column T as a value equal to x then this row between Column B and Column
T need to font strikethrough and the pattern will be yellow. Complete this
format starting on row 5 to row 300.

Please help me complete this task using the Conditional Formatting.

Joe K.

 

[Gord Dibben]

Select B5:T300 and Format>CF>Formula is:

=$T5="x"


Gord Dibben MS Excel MVP