Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to get a CSE formula to work with conditonal formatting. When using CSEs with cells, you hit CTRL+SHIFT+ENTER, but it appears that this key combination doesn't register in the conditional formatting window. The alternative option is to create a CSE formula in a cell and then use that cell's value in the conditional format formula, but I'd really like to get it to work with the conditional formatting formula itself.

share|improve this question
    
I tried this a while back and wasn't able to get it to work either. I ended up doing as you said by putting the formula in another cell and referencing it in conditional formatting. –  CharlieRB Dec 11 '13 at 13:48
1  
I believe that all conditional formatting formulas work as array formulas, so just enter the formula with enter. Link –  gtwebb Dec 11 '13 at 17:27
    
@gtwebb, you should post that as answer and I will mark it because I just confirmed that you're correct. –  oscilatingcretin Dec 11 '13 at 17:35
    
There is a bug in Excel 2007 whereby "array formulas" used in CF don't work when worksheet is re-opened (unless you go back into CF first) so it's sometimes worth avoiding formulas that require CSE, there's usually a way to do that - which particular formula are you using here? –  barry houdini Dec 11 '13 at 22:43
    
@barryhoudini I am using 2010, not 2007. –  oscilatingcretin Dec 11 '13 at 23:09

1 Answer 1

up vote 1 down vote accepted

All conditional formatting formulas work as array formulas, so just enter the formula with enter.

Link to source

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.