Hi guys,
My sheet cells has numbers after the icons in column I.
how/why? I need to remove these.
pls advise!
Hi guys,
My sheet cells has numbers after the icons in column I.
how/why? I need to remove these.
pls advise!
Thanks,
R.
Hi,
in conditional formatting check "SHOW ICON ONLY"
There is an option in the CF dialog to include just the icon - I think it’s a tick box.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
They are there because you have formula that puts them there.
Your formula in I is =IF(H2="In progress",1,IF(H2="Completed",2,IF(H2="Not started",0))) which puts a 1 in the cell. If you don't want the numbers then remove the formula and go with only conditional formatting based upon the same criteria you used to put the numbers there.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks