Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I flag numbers that are higher/lower than a range of #'s
I am entering lab results and would like to compare the values reported to
the reference ranges and somehow flag them. I would like to make the < values red and the values blue, or make them with a "L" or "H." Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I flag numbers that are higher/lower than a range of #'s
Use Conditional Formatting.........Format ConditionalFormatting, and set
as "Cell value is" less than some helper cell and greater than some other helper cell and follow the menu for formatting options......... hth Vaya con Dios, Chuck, CABGx3 "Rick Parker" <Rick wrote in message ... I am entering lab results and would like to compare the values reported to the reference ranges and somehow flag them. I would like to make the < values red and the values blue, or make them with a "L" or "H." Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying numbers stored in a range??? | Excel Discussion (Misc queries) | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Searching a range of numbers for a specified total | Excel Worksheet Functions | |||
get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
Find Median of Positive numbers only in Range | Excel Worksheet Functions |