Read cell value and display

[Guest]

Hi,

How to I use vba to read the range of cell value in one column and based on
the font strikethrough condition, i only show the cell value?


thanks.

regards,
Ben

 

[Tom Ogilvy]

How about an example of what you mean by only show the cell value?

Do you want to hide rows that contain a strikethrough or something like
that?

Is all the text in the cell formatted for strikethrough or only some letters
within a string?

 

[Guest]

Hi Tom,

Below is the example.

example: column a b c d

text reboot Text is strikethrough in
column a
try text Text is strikethrough
in column b

where text is strikethrough.

thanks
regards,
Ben