Hi,
I am using excel to view values of several samples and controls. It looks something like this:
sample 1- 67
sample 2- 68
sample 3- 88
control 1- 10
control 2- 15
I am trying to use conditional formatting to highlight cells in a particular range.
This problem is I need to highlight samples if they are <20, but highlight controls if they are >35.
How can I use conditional formatting to format only every nth cell in a row?
all i can find is =MOD(ROW(),2)=1
but this can only be used to highlight, reguardless of the values
-also, the list is not only 5 cells deep it is hundreds of samples and controls. Always 3 samples, always 2 controls. So i would like something that will format all of the values that fall in the range
Bookmarks