see your other post for a suggestion regarding your type mismatch error.

" wrote:

Hello all,

I am currently employing a conditional format to a column
of cells, whose text colors are contingent on a set of conditions

=IF((J98<"")*(J98<" ")*(ISNA(MATCH(J98,$J$1:J97,0))),FALSE,TRUE)
'Magenta strikethrough text

=IF(AND(F98=1,G98<"Yes"),TRUE,FALSE)
'Red Text

=IF(OR(A98="Table 7",A98="table 7",A98="Table7",A98="table7"),
TRUE,FALSE)
'Regular, black text

Unfortunately, if any user selects a cell they want to edit in this
column (this is supposed to happen) without double-clicking on it
(hence the cell is active, but the cursor is not) & pastes data in - it
removes all of the conditional formatting for that cell.

I figured that the most sensible way around this is to write VBA
code that would handle this, but I'm not sure how to translate the
above conditions into VBA. Any help on this would be much appreciated.

Thanks.