I would like to format an entire column so that if there is any entry in column B (in the same row) the font in column A will be blue, if there is an entry in column C, the font will be red etc.
I can figure out how to do the formatting one row at a time but I'd like to be able to format the first row and have the same rule in every row without having to manually put it in.
Thanks for your help!
Conditional formatting excel based on another column
Excel conditional formatting 5 color scale - Best answers
Excel conditional formatting entire column based on another column - Best answers