in the cell to the right use an if statement to get yoru value for example:
=IF(A1="Student was Bad","X","√")
then use conditional formating to change the colour of that cell based on the text value.
in the cell to the right use an if statement to get yoru value for example:
=IF(A1="Student was Bad","X","√")
then use conditional formating to change the colour of that cell based on the text value.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks