Example: A1 = 300 (Target) (Green color)
A2 = 145
A3 = 275
A4 = 375
A5 = 165
A6 = 225
A7 = 355
(It will not always be the same range of data being selected (A2:A7) may be less or more row.)
If any cell from A2:A7 become greater than A1, I want These Cell BLINK and/or Change Colors.
This will warn the users that the Max Target amount shown in cell A1 has been exceeded.
Thank you for your assistance.