lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I found it is hard to edit a formula in the Conditional Formatting -->New Rule-->Using Formula, box
When I click inside the box and then click any cell excel will enter the absoult value i.e $A$1
let say I wrote this formula =$A$1 >10
Later if i go to that box and to edit something for example deleting $ i can delete the first one but when I move to the next one using arrow key, excel will enter $B$1
Why is that? Thank you so much.
I found it is hard to edit a formula in the Conditional Formatting -->New Rule-->Using Formula, box
When I click inside the box and then click any cell excel will enter the absoult value i.e $A$1
let say I wrote this formula =$A$1 >10
Later if i go to that box and to edit something for example deleting $ i can delete the first one but when I move to the next one using arrow key, excel will enter $B$1
Why is that? Thank you so much.
