If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
#8
|
|||
|
|||
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? |
#9
|
|||
|
|||
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? |
#10
|
|||
|
|||
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? |
|
Thread Tools | |
Display Modes | |
|
|