Highlighting the entire row with conditional formatting

  • Thread starter Thread starter Allen
  • Start date Start date
A

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?
 
What rule(s) are you using to CF the row?

What cell value would return TRUE or FALSE


Gord Dibben MS Excel MVP
 
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).
 
Ok, let's try to figure this out:
I am using =AND(A5:BK5) in the 'Use a formula...
Click to expand...

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.
Click to expand...

What's that have to do with it?
 
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
 
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
 
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
 
Ok...
Column A contains days of the week
Click to expand...

Assuming the weekdays are TEXT entries.

Select the entire range A2:BK3000

Conditional Formatting>Use a formula to determine...

=LEFT($A2)="S"
 
Excellent, that works. Thanks a lot!

T. Valko said:
Ok...


Assuming the weekdays are TEXT entries.

Select the entire range A2:BK3000

Conditional Formatting>Use a formula to determine...

=LEFT($A2)="S"
Click to expand...
 
Back
Top