Hi,
I have a data table Table1 in the attached.
This will contain either a piece of text or blank. I want to conditionally format the cells in Table1 based on whether they are valid data. Valid data is the 3 text options in the Checklist (tblPhysicalActivity).
If the text is within the list then no formatting, but if the text is not in the list or blank then change formatting to red fill.
I have formatted Table1 to show how it should appear with conditional formatting on.
Try this as the CF rule...
=ISERROR(MATCH(A2,$G$2:$G$4,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Excellent.
Thanks Ford.
Happy top help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks