I was handed over an excel file which contains conditional formatting.
The formatting is based on both value and formula.
It looks like this.
My question is how do I edit the formula and where is it stored?
conditional formatting.JPG
I was handed over an excel file which contains conditional formatting.
The formatting is based on both value and formula.
It looks like this.
My question is how do I edit the formula and where is it stored?
conditional formatting.JPG
Google "Conditional format iconset"
there is plenty of reading material for you to understand the basics of it
http://www.excel-easy.com/examples/icon-sets.html
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks