Hi
I am a total beginner in excel and am putting together a speadsheet list of documents and would love to be able to write a formula function to speed formatting up.
Cell B gives the document number
Cell C gives the year of issue
Cell D gives name of document
Cell E gives hyperlink if document is active, and states "withdrawn" if the document has been withdrawn.
Now, what I would like to do to speed things up, is this:
If I type withdrawn in cell E, I would like that text to be red and bold, and I would like the text in cell D to strikethrough.
I would really appreciate your help!
Thanking you
Bookmarks