| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting for rows
I'm familiar with conditional formatting, but cannot figure out the formula
to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting for rows
Formula is: =IF($G1="visa",true,false)
Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating. -- Best Regards, Luke M "ExcelObsessed" wrote: I'm familiar with conditional formatting, but cannot figure out the formula to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting for rows
Thank you, but I'm asking specifically about conditional formatting. So,
going into format -- conditional formatting, I need to enter a formula to automatically highlight the entire row rather than just the individual cell. Thoughts? Thanks again! "Luke M" wrote: Formula is: =IF($G1="visa",true,false) Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating. -- Best Regards, Luke M "ExcelObsessed" wrote: I'm familiar with conditional formatting, but cannot figure out the formula to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting for rows
That is the formula to use with the conditional format. You can copy
conditional formats from one cell to another. Once you have the conditional format in once cell, copy, then select desired area(or all, with Ctrl+A) to be affected, and right-click, paste special. Choose format. -- Best Regards, Luke M "ExcelObsessed" wrote: Thank you, but I'm asking specifically about conditional formatting. So, going into format -- conditional formatting, I need to enter a formula to automatically highlight the entire row rather than just the individual cell. Thoughts? Thanks again! "Luke M" wrote: Formula is: =IF($G1="visa",true,false) Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating. -- Best Regards, Luke M "ExcelObsessed" wrote: I'm familiar with conditional formatting, but cannot figure out the formula to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting for rows
That worked! I was trying to format the whole range at once, but pasting
special as the format fixed that. Thanks!! "Luke M" wrote: That is the formula to use with the conditional format. You can copy conditional formats from one cell to another. Once you have the conditional format in once cell, copy, then select desired area(or all, with Ctrl+A) to be affected, and right-click, paste special. Choose format. -- Best Regards, Luke M "ExcelObsessed" wrote: Thank you, but I'm asking specifically about conditional formatting. So, going into format -- conditional formatting, I need to enter a formula to automatically highlight the entire row rather than just the individual cell. Thoughts? Thanks again! "Luke M" wrote: Formula is: =IF($G1="visa",true,false) Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating. -- Best Regards, Luke M "ExcelObsessed" wrote: I'm familiar with conditional formatting, but cannot figure out the formula to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting for rows
Glad it worked! Thanks for the feedback.
-- Best Regards, Luke M "ExcelObsessed" wrote: That worked! I was trying to format the whole range at once, but pasting special as the format fixed that. Thanks!! "Luke M" wrote: That is the formula to use with the conditional format. You can copy conditional formats from one cell to another. Once you have the conditional format in once cell, copy, then select desired area(or all, with Ctrl+A) to be affected, and right-click, paste special. Choose format. -- Best Regards, Luke M "ExcelObsessed" wrote: Thank you, but I'm asking specifically about conditional formatting. So, going into format -- conditional formatting, I need to enter a formula to automatically highlight the entire row rather than just the individual cell. Thoughts? Thanks again! "Luke M" wrote: Formula is: =IF($G1="visa",true,false) Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating. -- Best Regards, Luke M "ExcelObsessed" wrote: I'm familiar with conditional formatting, but cannot figure out the formula to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting for rows
Highlight row 2 by clicking on the row identifier, then click on
Format | Conditional formatting, select Formula Is rather than Cell Value Is and enter this formula: =ISNUMBER(SEARCH("visa",$G2)) Then click on the Format button, select the Patterns tab and choose your background colour. OK your way out. With row2 still highlighted, double-click the Format Painter icon, then click in A3, A4, A5 etc for all the rows that you want this effect to apply to - press <Esc when you are done. Hope this helps. Pete On Dec 7, 8:06 pm, ExcelObsessed wrote: Thank you, but I'm asking specifically about conditional formatting. So, going into format -- conditional formatting, I need to enter a formula to automatically highlight the entire row rather than just the individual cell. Thoughts? Thanks again! "Luke M" wrote: Formula is: =IF($G1="visa",true,false) Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating. -- Best Regards, Luke M "ExcelObsessed" wrote: I'm familiar with conditional formatting, but cannot figure out the formula to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks!- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting for rows
You could simply select Column G then FormatCFCell Value is: Equal to "visa"
without the IF, TRUE, FALSE formula. Or simply Formula is: =$G1="visa" Also without using the format painter. Gord Dibben MS Excel MVP On Fri, 7 Dec 2007 12:20:01 -0800, ExcelObsessed wrote: That worked! I was trying to format the whole range at once, but pasting special as the format fixed that. Thanks!! "Luke M" wrote: That is the formula to use with the conditional format. You can copy conditional formats from one cell to another. Once you have the conditional format in once cell, copy, then select desired area(or all, with Ctrl+A) to be affected, and right-click, paste special. Choose format. -- Best Regards, Luke M "ExcelObsessed" wrote: Thank you, but I'm asking specifically about conditional formatting. So, going into format -- conditional formatting, I need to enter a formula to automatically highlight the entire row rather than just the individual cell. Thoughts? Thanks again! "Luke M" wrote: Formula is: =IF($G1="visa",true,false) Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating. -- Best Regards, Luke M "ExcelObsessed" wrote: I'm familiar with conditional formatting, but cannot figure out the formula to highlight an entire row based on the contents in one cell. For example, for every cell in column G that contains the word "visa", I would like that entire corresponding row to be highlighted. Can anyone tell me the formula? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting rows | Excel Discussion (Misc queries) | |||
| Conditional Formatting of rows | Excel Discussion (Misc queries) | |||
| Conditional Formatting of Rows | Excel Discussion (Misc queries) | |||
| Conditional Formatting for rows... | Excel Discussion (Misc queries) | |||
| How to get more than 3 rows in Conditional Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
