Highlighting the entire row with conditional formatting

[Allen]

Hello, I am using the True/False condition to highlight an entire row through
conditional formatting but the highlighting stops where there is a zero in a
particular cell in the row I am trying to highlight. How do I highlight the
entire row regardless of what characters are in the cells of that row?

 

[T. Valko]

You'll need to tell us what condition is being used to apply the format.

 

[David Biddulph]

You forgot to tell us what conditions you are currently using in CF.

 

[Gord Dibben]

What rule(s) are you using to CF the row?

What cell value would return TRUE or FALSE


Gord Dibben MS Excel MVP

 

[Allen]

Sorry, I am using =AND(A5:BK5) in the 'Use a formula to determine which cells
to format' rule formula. I have a true/false NOT(IF) function at the end of
each row that results in True when cells in column B are >5.1. This applies
to $A$5:$BK$3000 (column BK has the true/false condition).

 

[T. Valko]

Ok, let's try to figure this out:

I am using =AND(A5:BK5) in the 'Use a formula...

What's in the range A5:BK5?

Explain in *words* what your condition is to apply the formatting.

I have a true/false NOT(IF) function at the end
of each row that results in True when cells in
column B are >5.1.

What's that have to do with it?

 

[Allen]

I have a table of data that is in a range A2:BK3000. Column A contains days
of the week. I am trying to highlight the complete row from A to BK when the
day of the week in column A is Saturday or Sunday

 

[Allen]

I have a table of data in the range A2:BK3000. Column A contains days of the
week and I want to highlight the entire row (A to BK) when column A shows
either Saturday or Sunday

 

[Allen]

I have a table of data in the range A2:BK3000. Column A contains days of the
week and I want to highlight the entire row (A to BK) when column A shows
either Saturday or Sunday

 

[T. Valko]

Ok...

Column A contains days of the week

Assuming the weekdays are TEXT entries.

Select the entire range A2:BK3000

Conditional Formatting>Use a formula to determine...

=LEFT($A2)="S"

 

[Allen]

Excellent, that works. Thanks a lot!

Ok...


Assuming the weekdays are TEXT entries.

Select the entire range A2:BK3000

Conditional Formatting>Use a formula to determine...

=LEFT($A2)="S"

 

[T. Valko]

You're welcome. Thanks for the feedback!