Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I conditionally format a cell Part 2
I have a log with possible duplicate information.
There are three sections; the first two columns are aligned for all three sections, like so: A B C part 1(date) Part 1 (name) info Part 2(date) Part 2 (name) other info Part 3(date) Part 3 (name) other other info I have conditional formatting in Part 1 based on information in column 3. I need Excel to recognize if the information in B1 is located anywhere else in the woorksheet. If it is I need that same format for the cell(s) in Part 2 and or 3. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |