ALERT function requested

[Deathwing]

Hi All

I've got an Excel table with each column being a client and it runs across many screens. Each client is set to display the word "ALERT" in red in its column if an action is due on that account, but to save me scrolling across the entire table each morning it would be really useful if in cell A1 I could put a function which will display a highly-visible ALERT if any client has an action due.

I had something like:

=IF(C28="ALERT","ALERT","")

which seemed to work ok for one cell but when I tried to expand it across the range (=IF(C28:AAT28="ALERT","ALERT","") it failed and just displayed the formula.

Does anyone have a function or similar I could put in that would work? The more visible the alert the better too!

Many thanks and all the best

Merlin

[romperstomper]

You could use:
=IF(COUNTIF(C28:AAT28,"ALERT"),"ALERT","")

[Deathwing]

Great, that works well, thank you!

[romperstomper]

Glad to help.