Conditional Formatting excel

[GN100]

I have an excel sheet with a price target in column A and a current price (scraped) in Column B. I want the price target (A) to change colour when the current price (B) has equalled or exceeded it.

I have been trying various methods without much luck - help appreciated.

GN

[mc2fool]

You might like to say which version of Excel you are running, as the interface for Conditional Formatting has changed a fair bit over the years.

That said, something along the lines of this Conditional Formatting with Formulas is what you want (assuming yours looks anything like this).

Do it just to the first relevant cell in column A, let's say A2, and set the formula to be "=A2>=B2" (without the quotes). Then copy A2 and Paste Special just Formats to all of column A.

[GN100]

Thanks - that was just what I was looking for. Apologies re not giving the excel version - I'm somewhat ashamed to say I can no longer find it. It used to be under Help - About but is no longer there.

Regards,
GN

[pje16]

Thanks - that was just what I was looking for. Apologies re not giving the excel version - I'm somewhat ashamed to say I can no longer find it. It used to be under Help - About but is no longer there.

Regards,
GN

Try File, and at the bottom select 'Account'

[GN100]

Thanks pje - it looks like it is MS Office Professional Plus 2016. I had forgotten I was that up-to-date!!

GN

[GrahamPlatt]

I thought I’d seen this somewhere before… viewtopic.php?f=39&t=35196