Embarking on an idea out of my depth....

[Jlombard_]

I’m trying to create a ‘test’ function within excel where I can enter subject headings from an email and then they’ll either be approved or rejected based on various criteria.
Here are the criteria;
- Text length between 18-25 characters
- Any words on a ‘bad’ list will flag the input (and the word if possible) (hidden sheet)
- Any words on a ‘good’ list will flag the input (and the word if possible) (
- If the test is ‘approved’ the subject text would then follow through underneath or perhaps with a tick symbol?
- If the test was ‘rejected’ the subject text in the test highlights the box in red?
- I’d also want the cell with ‘text’ written in it to work also?
I’m awful with excel and it’s something I’m fairly new too, aside from the odd report it’s something I don’t have much familiarisation with, especially on this level. – so is this possible and if so does anyone fancy helping me build it?

 

[Joe4]

Cross-posted here: https://www.excelguru.ca/forums/showthread.php?9439-Embarking-on-an-idea-out-of-my-depth

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.