| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
I'm having difficulty doing a comparison format. Data appear as follows: ..........A B C D E F G Row 1: 1 1 2 1 2 1 1 Row 2: 2 1 2 1 1 2 1 What I want to do is compare row 1 with row 2, and highlight BOTH values if they are different. ie. A1 = 1, A2 = 2 -- I want both these values to be formatted to indicate they are different. The desired end result here would be to have A1, A2, E1, E2, F1 and F2 formatted to stand out. Suggestions? Thanks! -- SlipperyPete ------------------------------------------------------------------------ SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220 View this thread: http://www.excelforum.com/showthread...hreadid=520644 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
