Good morning, I have the following formula in a cell and works great:
=(IF(AA2<NOW(),"Expired","OK")
What I would like to do is replace the word "Expired" by a red X and the word "OK" by a green checkmark in the result cell itself
When applying the conditional formatting, you have Icon, Value and Type, what would you insert in the "Value" section?
Thanks
Bookmarks