Dexter1759
New Member
All,
I'm currently setting up a template in Excel 2007. On a worksheet I have an Excel Table that the user can add rows to. I'd like to include a "helper" column on this table that shows some red text to the user indicating if there's something they need to do/resolve.
A couple of example of the help text and conditions would be:
Also, I don't mind if the text shown is either the first condition passed, or a concatenation of all conditions.
I hope I've explained myself fully enough, if not please feel free to nudge me for clarification.
I should say as well that I'm looking for a way to do this with formulae rather than VBA, due to performance concerns.
Many thanks,
Dex
I'm currently setting up a template in Excel 2007. On a worksheet I have an Excel Table that the user can add rows to. I'd like to include a "helper" column on this table that shows some red text to the user indicating if there's something they need to do/resolve.
A couple of example of the help text and conditions would be:
- "Duplicate value in column X" - where COUNTIF of current value in X is >1.
- "Data is required in column Y" - where a specific column is blank. This could even be reliant on the value of another column, e.g. If Column Z is "this", Column Y cannot be blank, display message.
Also, I don't mind if the text shown is either the first condition passed, or a concatenation of all conditions.
I hope I've explained myself fully enough, if not please feel free to nudge me for clarification.
I should say as well that I'm looking for a way to do this with formulae rather than VBA, due to performance concerns.
Many thanks,
Dex