Hi all,
I have Excel 2011 and I am trying to do conditional formatting over the cells in column V.
I want to format the cells such that if anyone enters anything other than the specified pick list values, it get highlighted.
I am using this formula:
=NOT(OR($V2="G2MC - Sales",$V2="SF - Finance",$V2="G2W - Marketing", $V2="G2W - HR", $V2="SF - Business leader", $V2="SF - Finance",$V2="G2A - IT Management",$V2="G2AC - Support",$V2="G2A IT Consultant / MSP",$V2="G2C - Business Managers",$V2="G2C - IT"))
However it's still highlighting certain values like "G2A - IT Management"
Also I have more picklist values to be included in this formula but there seems to be a character limit to the formula.
If I do apply a new rule to include the remaining values, I want both rules to work at the same time and not to take precedence over the other.
Can someone please help me with this query?
Thanks!
Bookmarks