Changing a Formula in Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a formula in conditional formatting and I want to edit the formula.
However, when I click in the formula and try to move around in the formula
using the arrow keys, cell references and $ appear in the formula. How do I
edit a formula that I have placed in conditional formatting. I am using Excel
2003

Thanks very much for your help.

Regards,

Dee
 
When you insert conditional formatting formula, pressing the arrow keys,
Excel automaticaly inserts cell addresses in text box in dialog. To edit
formula in conditional formatting dialog, click in formula (or select part
of the formula) with your mouse, and winput changes by keyboard.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
conditional formatting update issue 5
Excel VBA 1
IF OR AND in same conditional formula 2
Conditional Formatting Formula Not Working 1
Conditional Cell Formatting 5
Conditional Formatting Amendment 2
Conditional Formatting Formula 1

Back
Top