ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Changing a Formula in Conditional Formatting (https://www.excelbanter.com/excel-worksheet-functions/53353-changing-formula-conditional-formatting.html)

Dee

Changing a Formula in Conditional Formatting
 
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

Mladen_Dj

Changing a Formula in Conditional Formatting
 
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.

"Dee" wrote in message
...
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





All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com