Forum Discussion
Solved
How to Navigate the "Applies To" Box for Conditional Formatting
My question is how to navigate the "Applies to" Box for Conditional Formatting when wanting to edit the cells for which the conditional formatting applies. Since my list of cells and cell blocks is q...
Once you click inside the Applies to TextBox, press the F2 function key to go into Edit mode and then you can use the right or left arrow key to navigate.
Thank you so much!! I can't believe how many years have passed and I didn't know that!! It drove me so crazy that's why I joined this site so I could ask this question! Haha!
You're welcome! Glad I could help.
Btw, you selected your own post as a Best Response. Please take a minute to accept the post with the proposed solution as a Best Response to properly mark your question as Solved.
- Thanks! It took me a while to figure out how to fix that (marking my response as the best response instead of yours) but I think I got it! 😁
- Yes, you did it right. Thanks!