Can I flag numbers that are higher/lower than a range of #'s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a formmula change in a "flag" parameter! 19
price higher than... 2
Conditional Formatting from a group 6
Trying to find additional ranges outside of min, max, and average 2
How do I have a cell value define a dynamic named range? 15
Extracting elements of a string cell 11
Triggering a Flag after 10 days that excludes weekends and holiday 3
Having a cell flag me 1

Back
Top