| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighting cells
Hi,
I have a tables of names, and I would like the name to be highlighted when selected in a different cell, example table 1 in cells a1 john a2 jim a3 jayne when cell a5 is equal to john, I would like john to be highlighted, many thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlighting cells
Apply conditional formatting for the table, condition: cell value/ equals/
=$A$5 Regards, Stefi robbie ezt *rta: Hi, I have a tables of names, and I would like the name to be highlighted when selected in a different cell, example table 1 in cells a1 john a2 jim a3 jayne when cell a5 is equal to john, I would like john to be highlighted, many thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i prevent continued highlighting cells when cursor moves? | New Users to Excel | |||
| Highlighting cells between two workbooks. | Excel Discussion (Misc queries) | |||
| highlighting cells when reaching certain numbers | Excel Discussion (Misc queries) | |||
| Cells in Excel will not stop highlighting | Excel Discussion (Misc queries) | |||
| Curser not highlighting cells | Excel Discussion (Misc queries) | |||
Linear Mode
