0

How can I use conditional formatting to highlight a cell based on an entered cell reference?

For eg,

If I enter A1, cell A1 must be highlighted.

Thank you in advance!

1 Answer 1

1

Try this formula:

= SUBSTITUTE(ADDRESS(ROW(A1), COLUMN(A1)), "$", "")=$A$1

enter image description here

1
  • Thanks a lot :) I used = ADDRESS(ROW(A1), COLUMN(A1), 4) instead of the SUBSTITUTE function.
    – Shub
    Jan 31, 2021 at 8:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .