Conditional Formatting for Entire Row

  • Thread starter Thread starter Nordic
  • Start date Start date
N

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
 
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
 
Back
Top