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 |
#11
|
|||
|
|||
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? |
#12
|
|||
|
|||
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? |
|
Thread Tools | |
Display Modes | |
|
|