I'm trying to get a cell
C3 to highlight using conditional formatting, but based on a value in 4 other cells.
If 4 continuously adjacent cells (e.g.
AV3) contain the
X value only then do I want the cell
C3 to highlight, so NOT if they are not joined together.
(It's a worksheet to highlight absences, 4 times in a row).
How would I go about this?