Conditional Formatting, Criteria from a Table

H

Howard

Let me explain what I am tring to do. I send tissue(leaf) samples from
different agricultural crops to a lab. The send back a report with the levels
of all the essential elements. I then paste them into a spread sheet. there
is a high, low and normal level. These criteria levels will also very
depending on the stage of plant growth, vegetative, early bloom, fruit set,
harvest and etc. Also differant crops have different criteria levels.
I want to paste these results into spread sheet. I then want to enter the
crop stage (number) to the right of the appropriate sample and the element
value in the cell to change color to represent high, normal or low. These
values would come from a table I have setup for each stage of crop growth.
I would also like to set it up so that I could change crops on the same
spread sheet, that is have several crops on the same page. I already have a
spread sheet that will only do 1 crop stage at a time. When I change the
stage of crop growth it changes for all rows(samples) on the sheet.
Thank you
Howard
 
G

GoodTrouble

Have you tried using the Conditional Formatting Function Under the Format
menu?
 

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

Top