Status Column to Flag Red Or Green - (different rows have different range)

Vinton Douglas

I am having an issue and need some assistance.

I have 3 columns A, B and C

Column A- Lower range (a number)

Column B - Upper range (a number)

Column C - Status Column (Red, Amber and Green dots)

I have several rows with different upper and lower ranges

I want the status column to flag 'Red' if its above or below the ranges and 'Green' if it is within the normal range. Please note that each row may have different upper and lower ranges.

Can any one assist?

Paul Newcome

It would be something along the lines of

=IF(AND([Column Name]@row>= [Lower Range]@row, [Column name]@row<= [Upper Range]@row), "Green", "Red")

Paul Newcome

It would be something along the lines of

=IF(AND([Column Name]@row>= [Lower Range]@row, [Column name]@row<= [Upper Range]@row), "Green", "Red")

Vinton Douglas

Many thanks. It works like a charm.

Paul Newcome

Happy to help. 👍️