Highlighting the entire row with conditional formatting
 

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?

Highlighting the entire row with conditional formatting
 

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?

Highlighting the entire row with conditional formatting
 

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

Allen wrote:
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?

Highlighting the entire row with conditional formatting
 

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

What cell value would return TRUE or FALSE


Gord Dibben MS Excel MVP



On Tue, 14 Apr 2009 12:45:02 -0700, Allen
wrote:

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?

Highlighting the entire row with conditional formatting
 

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" wrote:

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?

Highlighting the entire row with conditional formatting
 

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?

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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" wrote:

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?

Highlighting the entire row with conditional formatting
 

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

"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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" wrote:

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?

Highlighting the entire row with conditional formatting
 

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

"Gord Dibben" wrote:

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

What cell value would return TRUE or FALSE


Gord Dibben MS Excel MVP



On Tue, 14 Apr 2009 12:45:02 -0700, Allen
wrote:

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?

Highlighting the entire row with conditional formatting
 

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" wrote:

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?

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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" wrote:

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?

Highlighting the entire row with conditional formatting
 

Ok...

Column A contains days of the week

Assuming the weekdays are TEXT entries.

Select the entire range A2:BK3000

Conditional FormattingUse a formula to determine...

=LEFT($A2)="S"

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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

"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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" wrote:

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?

Highlighting the entire row with conditional formatting
 

Excellent, that works. Thanks a lot!

"T. Valko" wrote:

Ok...

Column A contains days of the week

Assuming the weekdays are TEXT entries.

Select the entire range A2:BK3000

Conditional FormattingUse a formula to determine...

=LEFT($A2)="S"

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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

"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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" wrote:

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?

Highlighting the entire row with conditional formatting
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
Excellent, that works. Thanks a lot!

"T. Valko" wrote:

Ok...

Column A contains days of the week

Assuming the weekdays are TEXT entries.

Select the entire range A2:BK3000

Conditional FormattingUse a formula to determine...

=LEFT($A2)="S"

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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

"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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" wrote:

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

--
Biff
Microsoft Excel MVP


"Allen" wrote in message
...
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?