In a range, say A1:D5, I need to format cells as follows:
1) If cell contains only "H" or "HV": highlight red
2) If cell contains only a number: highlight blue
3) If cell contains a number with the letter "F" ("1 F" or "5.5 F"): highlight pink
I would like to use conditional formatting.
Any help would be much appreciated. I would be happy to provide an example if this explanation is too confusing!
Thanks
Bookmarks