| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting results
i have done a search and if the data was a match i gave a "1" and if not a
"0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlighting results
Using Conditional Format
Format/conditional format/ cell value = 1, selecting the format you want. best Wishes Sreedhar "bkunes" wrote: i have done a search and if the data was a match i gave a "1" and if not a "0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlighting results
this works for one cell but i want to highlight that cell and the entire row
that it is in -- "yshridhar" wrote: Using Conditional Format Format/conditional format/ cell value = 1, selecting the format you want. best Wishes Sreedhar "bkunes" wrote: i have done a search and if the data was a match i gave a "1" and if not a "0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlighting results
If so B1=
format/conditional formating/formula is =$a1=1, select the format copy the fomats to C1,D1... Adjust the range according to your worksheet best wishes "bkunes" wrote: this works for one cell but i want to highlight that cell and the entire row that it is in -- "yshridhar" wrote: Using Conditional Format Format/conditional format/ cell value = 1, selecting the format you want. best Wishes Sreedhar "bkunes" wrote: i have done a search and if the data was a match i gave a "1" and if not a "0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlighting results
that didnt work any ideas
-- "yshridhar" wrote: If so B1= format/conditional formating/formula is =$a1=1, select the format copy the fomats to C1,D1... Adjust the range according to your worksheet best wishes "bkunes" wrote: this works for one cell but i want to highlight that cell and the entire row that it is in -- "yshridhar" wrote: Using Conditional Format Format/conditional format/ cell value = 1, selecting the format you want. best Wishes Sreedhar "bkunes" wrote: i have done a search and if the data was a match i gave a "1" and if not a "0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlighting results
In CF you don't want to use Cell Value Is, but instead you need Formula Is/
=$A1=1 Amend your cell reference as appropriate, but notice the *absolute* reference for the column and *relative* address for the row. I have assumed that you are loking for a number 1, but if you want to look for the text string, change it to =$A1="1" -- David Biddulph "bkunes" wrote in message ... this works for one cell but i want to highlight that cell and the entire row that it is in "yshridhar" wrote: Using Conditional Format Format/conditional format/ cell value = 1, selecting the format you want. best Wishes Sreedhar "bkunes" wrote: i have done a search and if the data was a match i gave a "1" and if not a "0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlighting results
it highlights but not correct row
-- "David Biddulph" wrote: In CF you don't want to use Cell Value Is, but instead you need Formula Is/ =$A1=1 Amend your cell reference as appropriate, but notice the *absolute* reference for the column and *relative* address for the row. I have assumed that you are loking for a number 1, but if you want to look for the text string, change it to =$A1="1" -- David Biddulph "bkunes" wrote in message ... this works for one cell but i want to highlight that cell and the entire row that it is in "yshridhar" wrote: Using Conditional Format Format/conditional format/ cell value = 1, selecting the format you want. best Wishes Sreedhar "bkunes" wrote: i have done a search and if the data was a match i gave a "1" and if not a "0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlighting results
That sounds as if you haven't put the right formula in the right cell. Look
again at your data and at your formula. What formula do you have in which cell? -- David Biddulph "bkunes" wrote in message ... it highlights but not correct row "David Biddulph" wrote: In CF you don't want to use Cell Value Is, but instead you need Formula Is/ =$A1=1 Amend your cell reference as appropriate, but notice the *absolute* reference for the column and *relative* address for the row. I have assumed that you are loking for a number 1, but if you want to look for the text string, change it to =$A1="1" -- David Biddulph "bkunes" wrote in message ... this works for one cell but i want to highlight that cell and the entire row that it is in "yshridhar" wrote: Using Conditional Format Format/conditional format/ cell value = 1, selecting the format you want. best Wishes Sreedhar "bkunes" wrote: i have done a search and if the data was a match i gave a "1" and if not a "0". Now is there a way to highlight an entire row of coresponding data if that one column ="1" -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
| highlighting cells that have desired results | Excel Discussion (Misc queries) | |||
| Highlighting a Row | Excel Worksheet Functions | |||
| How do I configure excel to show results when highlighting cells? | Excel Discussion (Misc queries) | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Hybrid Mode
