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 have defined a conditional formatting for a cell like equal to 'a' but it seems Excel checks conditional formatting after I select another cell (and un-focus the cell which has conditional formatting).

Is it possible to make Excel check conditional formatting on key press?

share|improve this question
add comment

1 Answer

Yes and No.

To literally answer your question; Yes, if you press Tab or Enter which changes the focus as you said.

To answer your question as I believe you meant to ask it; No, if you want it to perform functions as you type. Excel basically pauses as you are entering data, because it can not tell when you are done, until you change cells. When you do change cells, it then knows you are done entering data into that cell and applies the conditional formatting or calculates formulas.

share|improve this answer
add comment

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.