Hello again,
Hopefully another easyish question.
I have a worksheet that i wish to perform some conditional formatting on.
There is some descriptive text in cells A1 and A2. From A3-A10 there are some cells where any number of them could be marked off with an 'X'.
If any of the cells from A3-A10 contain an X, I would like the colour of the row from A1 through to A10 to change to say, red.
This is the same for row B, C, D etc.
I have managed to get single cells to change, but am struggling with rows. I am also struggling with the fact that it could be an X in any number of cells, rather than saying cell A5=X, for example.
Hope this makes sense, any help would be gratefully appreciated.
Many thanks,
Mark
Bookmarks