| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I put a strikethrough in cell if other cell has same info?
Assuming your 6 cells were A1:A6 and the other range was say E3:H16, selecet
A1:A6, hit Format / Conditional Formatting, change 'cell value is' to 'formula is' and drop in =COUNTIF($E$3:$H$16,A2)0 hit the format button on the dialog box, choose the foint tab and select strikethrough. Now just hit OK. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) "icntdrve55" wrote: I would like to find out how to have six cells in excel that have letters representing names in it, be strikethrough if I put one of those same letters (initials) in another cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| insert date | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Linear Mode
