Hi everybody,
I am a medical student in Turkey,
we have at least 3.000 kids controlling every week by their blood values.



They all have 3 lab results

0 to 60 yellow
60 to 360 black
+360 red

is there any way to make this automaticly? any setting of row or formula?

i can provide a exemple if needed.

Hi

by all means, post a small sample sheet ( no pic please)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

https://www.dropbox.com/s/qir295kcws...tabolizma.xlsx

here it is, what i try to describe

https://www.dropbox.com/s/qir295kcws...tabolizma.xlsx

here it is

Thank you
however external links being potentially unsafe, it would be advisable to post on the forum.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

here it is

Attached Files

metabolizma.xlsx (9.9 KB, 9 views)

See the attached file for conditional formatting, select column E > Home Tab > Condition Formatting > Manage Rules.

Attached Files

metabolizma-A.xlsx (15.9 KB, 10 views)

there are 3 different age intervals. consequently the lab result of the older children are prone to show high interval. the age between 0-3 shows results between 60-360 whereas the age between 3-9 shows results between 100-600. we seperated them according to their intervals of the results however as the interval varies there may be an overlapping interval. We need the excell to show us the optimum result and indicate if the result is abnormal for that interval yet normal for another interval. Group A 200-900 normal Group B 60-360 normal Group C 120-600 normal If i write A 150 it needs to show black, but if i write same value with A that must be yellow.

So where was the mention of 3 different age intervals in you original question! Perhaps you need to start a new thread for your question in your last reply.

thanks, i'll create a new thread.