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.
|