What to put into formula to determine conditional formatting to reference current cell? E.g. I want to make conditional formatting for if cell contains error (#N/A) and use the same rule for the entire column.
Cant seem to find how to reference the cell for which the function is being evaluated. Is it even possible?
Best Answer
Suppose the data range to conditionally format is A2:A10.
A2
.=ISNA($A2)
.$A2:$A10
.