Hello, I am trying to find out whether it is possible to have Excel flag up formula results outside a certain benchmark. To illustrate: for research into shares I want to set up a sequence of simple equations (x=y/z) over the course of a year. What would be brilliant were if I could tell Excel to highlight the result if it falls below a certain value, let's say x = 5 (or lower). With highlighting I mean, for example, displaying the result in red or bold or underlined ....
Therefore the questions are, is that possible at all and if so what do I have to do?
Any help is much appreciated
Thank you
Michael
Bookmarks