How do I do this? I would like a cell in a column to be formatted based on a
condition of a different cell in that column

"Dave O" wrote:

Yes! However, conditional formatting cannot be evaluated based on
cells in different tabs or spreadsheets.