| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL
Hi all,
I want to highlight a row based on the contents of a single cell. EG K23 has "XX" I want to highlight the whole of row 23. It has to be based on that cell only as columns on either side also contain "xx" and i dont want to inclued these in the calculation. Any help would be much apprietated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL
Select all of row 23 (or however much of it you want highlighted
Format/Conditional formatting Formula is =$K$23="XX" then select your format preference. "Chopper" wrote: Hi all, I want to highlight a row based on the contents of a single cell. EG K23 has "XX" I want to highlight the whole of row 23. It has to be based on that cell only as columns on either side also contain "xx" and i dont want to inclued these in the calculation. Any help would be much apprietated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL
Thanks JMB,IT WORKED A TREAT.
Now i need to know if there is a way of applying this Formula to the whole sheet. EG When there is "xx" in cell k23 or l23 or m23 then 23 is highlighted. I want to do this from row 2 through to row 32. Chopper Select all of row 23 (or however much of it you want highlighted Format/Conditional formatting Formula is =$K$23="XX" then select your format preference. "Chopper" wrote: Hi all, I want to highlight a row based on the contents of a single cell. EG K23 has "XX" I want to highlight the whole of row 23. It has to be based on that cell only as columns on either side also contain "xx" and i dont want to inclued these in the calculation. Any help would be much apprietated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL
So if K2 = "xx", highlight only row 2 and if K23="xx", highlight only row 23?
If so, select rows 2:32 and try this formula in your conditional formatting: =SUMPRODUCT(--($K2:$M2="xx"))0 If you want rows 2:32 dependent on K23:M23 and not columns K:M of their respective rows, try =SUMPRODUCT(--($K$23:$M$23="xx"))0 "Chopper" wrote: Thanks JMB,IT WORKED A TREAT. Now i need to know if there is a way of applying this Formula to the whole sheet. EG When there is "xx" in cell k23 or l23 or m23 then 23 is highlighted. I want to do this from row 2 through to row 32. Chopper Select all of row 23 (or however much of it you want highlighted Format/Conditional formatting Formula is =$K$23="XX" then select your format preference. "Chopper" wrote: Hi all, I want to highlight a row based on the contents of a single cell. EG K23 has "XX" I want to highlight the whole of row 23. It has to be based on that cell only as columns on either side also contain "xx" and i dont want to inclued these in the calculation. Any help would be much apprietated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Conditional Formatting (Hightlight row based on one condition) | Excel Discussion (Misc queries) | |||
| Change text on one cell based on text in another | Excel Discussion (Misc queries) | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
Linear Mode
