How to check the same formula is throughout the column - Conditional Formatting

[eli_m]

Hi,

Is there a way I can do conditional formatting to check if the FORMULA of Y200 is in every cell in column Y?

I have this in conditional formatting and it kind-of works:
=AND(ISFORMULA(Y3),NOT(Y3=Y$200))

But it's more checking the value than the actual formula itself.

I also want to do this for my whole spreadsheet that each column checks CELL 200 of that same column and shows RED if the FORMULA isn't the same as CELL 200

Thanks in advance!

 

[6StringJazzer]

You want to highlight a cell in column Y if the formula in that cell is not identical to the cell in row 200 of that column?

Try this:

=FORMULATEXT(Y3)<>FORMULATEXT(Y$200)

 

[eli_m]

You want to highlight a cell in column Y if the formula in that cell is not identical to the cell in row 200 of that column?

Try this:

=FORMULATEXT(Y3)<>FORMULATEXT(Y$200)

amazing! thank you so much

 

[6StringJazzer]

You're welcome--glad it worked!