Computer Hope
Software => Computer software => Topic started by: fuzzy19 on December 18, 2008, 05:23:50 PM
-
I need to see if there is a formula that can be written to identify low or high values.
Example I have a value of 10 the range is 8-12,
if the value is lower or higher then the range can excel color code them so that I would be able to sort the out of range values without having to manually review each value.
-
Yea, its pretty easy actually. Highlight the column that has the numbers in it that you want to sort, then on the Home tab on the ribbon, click "conditional formatting" in the styles group, then go highlighted cells rule, then either greater then or less than, then enter the number you want to. Hope this helps :)
-
O, nevermind. Thats only if you know the actual range. Sorry, im not too sure of an actual formula. Sorry :(
-
I got it trial and error I used the following formula:
=(E26)<(G26)>(H26)
-
Are you saying that formula generates color coding of cells? ???
-
It will highlight the cells that fall under the conditional formatting rule. It's not the formula that does the color coding, it's excel that colors it based on whether or not the formula applies.
-
That was my point. His reply seemed to say he merely put the formula in a cell. But, conditional formatting is needed to change cell colors. Also, the formula doesn't make sense. I opened Excel and copied the formula to a cell. The value in H26 can be anything; it has no effect on the other cells.