Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .