Conditional Formatting for Entire Row

[Nordic]

Hello:

I am trying to setup conditional formatting to format the entire row based on
the contents of a single cell in that row. Specifically, if PercentCompleted
column says "100%" then format the entire row in Strikethrough.

Any assistance greatly appreciated.

- Nordic

 

[Gord Dibben]

Select the entire set of rows to format.

Then Format>CF>Formula is: =$G8=100%

Assuming Column G is PercentCompleted column.

Not the $ sign which locks the column reference but not the row reference.

Format to Strikethrough and OK your way out.


Gord Dibben MS Excel MVP

 

[Nordic]

Wiorked perfectly. THANKS!