I am trying to create a formula so that if the “Text”(name) in cell G49, which will change now and then, finds one or more “Matches” in the range E56:P60 the text of these duplicate names in the cells will turn Bold & Red but if G49 is blank nothing changes.
I am familiar with C.F. and I have tried "Match(G49)=" and Countif but these didn’t seem to work. Can anyone help please?
Thanks for looking.
Bookmarks