Excel Function to return values over a certain number - please help

[brewcitybiz]

I have a report that is rather long and requires being checked on a monthly basis - security by security - to see if it has a Yield in excess of a certain value. I was wondering if anyone knew of a way to more efficiently and accurately check this report - I currently have to go item by item manually. Whether it be a VLOOKUP or some other function in excel I am unfamiliar with - anything would be better at this point.

It is a standardized report that has a repeating set of information in a single column:

Security Name
Yield
FX Rate
Settled (the actual word)

The Yield is the item I wish to find out whether or not there are any values greater than 20. The number does not show as a percentage but as a whole number. The only two numbers taht would show in this column are either the Yield or the FX Rate. The FX Rate will never be greater than 1.0. Any help with this would be greatly appreciated. Thank you.

[MarkinTX]

Can you upload a sample spreadsheet?

[FDibbins]

couple of ideas come to mind. 1 is to use conditional formatting to highlight the yie4ld when it exceeds your criteria.

another would be to use =if(yield<value,"CHECK YIELD","")

without a sample workbook to work from, its hard to say tho

[brewcitybiz]

Here is a sample spreadsheet of the report I am working with - the page continues to repeat itself for several pages - I only included one which should be satisfactory - if you would be better served with the whole report I will be happy to attach it.

Those both sound like they could work really well - I hope this attachement give you an exact idea of what would work.

And thanks for the help!

[MarkinTX]

Highlight column F, conditional formatting
Highlight cells BETWEEN 20 and 1000 (as long as no yeilds will be over 1000)

over number.jpg

[brewcitybiz]

Thank you very much - that worked great.

[MarkinTX]

Glad that worked for you.

Dont forget to mark your post as [Solved], and its always appreciated if you click the star in the bottom left of the post to add points to the person that solved your problem.