Hi All,
If I have a cell with certain text in it, in another cell can I format this to show an icon?
For example, A1 says "hello" and I want a conditional format in B1 that looks at A1, sees it says hello and produces a tick or something...
Thanks
Jake
Without using Conditional Formatting...
In A1 Cell
Hello
In B1 Cell
Formula:
=IF(A1="Hello","a","")
Change the B1 cell font to Webdings
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Brilliant. An easier solution. Thank you
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks