Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Jean-Guy
The format is very simple : =C55<"Home" * taken from the middle of the report. The cell is highlighted if the condition is true. So, if B1 is Bob and the cell is highlighted; I need all other cells with the value Bob to also be highlighted. In the second and third parts the information in column C is different. Part 1 has "home" or an acrynom for another company. Part 2 and 3 does not have anything in Column C so I cannot continue the format through the spreadsheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I conditionally format only some of the text in a cell? | Excel Worksheet Functions | |||
how can I conditionally format a cell based on the value in a diff | Excel Discussion (Misc queries) | |||
How to conditionally format entire row from contents of one cell? | Excel Discussion (Misc queries) | |||
Excel can't conditionally format a cell if it contains a formula | Excel Worksheet Functions | |||
Conditionally format one cell for contents of another? | Excel Worksheet Functions |