| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting to find duplicates
I have followed directions from MS online help to use conditional formatting
to find duplicates. However, when I "paste special" the formatting into all of the cells, the CF stays the same and does not change from cell to cell. For example, I used the following formula: ="COUNTIF (L:L,L2)1" but when I pasted this CF to all other cells, L2 remains absolute. Is there help for me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in excel conditional formatting find the greatest value in 4rows | Excel Worksheet Functions | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Can I select a select with Conditional Formatting? | Excel Worksheet Functions | |||
| conditional formatting on a PivotTable? | Charts and Charting in Excel | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
Threaded Mode
