assistance with conditional formatting

**PeterG** · 04-27-2005, 07:03 AM

Hi folks,

I need some help with conditional formatting.
I have a spreadsheet that shows an end elevation of a fan, it has 4 fan blades that sit diagonally. Depending on whether an option is selected will determine whether the diagonal is shown or not. I have the conditional formatting working for drawing box sections which works fine. My problem is that under the formatting border option within Conditional Formatting is greyed out. How can I get this option enabled?

I have attached a screen dump to show what I'm blethering on about.

**PeterG** · 04-27-2005, 11:28 AM

Its ok, I have worked out a work-around. using text set at 45degree angle and IF function. I filled the cell with -'s and set to 45degrees, using an IF statement, the cell is told to either display the dashes or not.
Works a treat.

**dhruti85chavda** · 10-29-2015, 05:18 PM

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!

**FDibbins** · 10-29-2015, 05:39 PM

dhruti85chavda welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Having said that, perhaps Data Validation would be a better fit for you?