I have used conditional formatting to change the font colour in one cell (K22) depending on the initials that are used. I need the adjacent cells (L22 to O22) to change to the same font colour. Can you please help with this? I believe I might need to do this via formulae within the cells, but not sure.
Also, if there are merged cells in the row, will it make a difference?
Bookmarks