Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe K. - 11 Oct 2007 03:03 GMT

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.

Reply to this Message

Gord Dibben - 11 Oct 2007 03:29 GMT

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

=$T5="x"

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 3 lines]
>
>Joe K.

Reply to this Message