Hi,
I'm trying to find a way to (if I highlight a column) I can use conditional formatting to say only to format those cells in that column that have a number entry but to ignore cells that have words or blanks.
I want to then say if the cells with figures are above or below the adjacent cell to the right of it then change colour if the value of the cell is either above or below that adjacent cell. (Office 365 version)
Any ideas?
Lew
Bookmarks