Currently I add "FF" & "ENG" in columns and turn a cell grteen when ≥3. Is there a way to satisfy a cell only when their is a minimum of 2 "FF" and a minimum of 1 "ENG". At all times of the day I need at least 2 "FF" & 1 "ENG". I attached a snapshot of what I have.Doc3.docx
If you are using this in CF, then maybe something like this?
=AND(countif(A:A,"FF")>1,countif(A:A,"ENG")>0)
(untested)
Also, why upload a word doc for an excel question? Rather, upload a sample excel workbook
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
LOL...That is a good question.
Works great, thanks.
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks