Hi there, at work I export files to excel from a database called Anaplan. Some of the values in the export have blue font.
I need to do an IF statement based on the font color in cells - i.e. if that row contains any cells with blue font then give me this, if not (i.e. if that row only contains cells with black font then give me that.
Please see attached.
Can it be done without VBA?
I have Office 365.
Thanks
Bookmarks