[cag0331]

I have a spreadsheet that is basically measurements of a whole list of items over time so they each have one row and the number of columns per item changes based on the number of measurements taken. Each measurement fills 2 columns: one for the date and the other for the measurement. Say these are measurements of plants and there is a date that there was one kind of fertilizer added at the beginning of each row and then a second date right next to that for when someone sang to the plants. I want each set of measurements to be formatted so that if the measurement was taken before the first fertilizer date it should be red, if it is between the fertilizer date and the singing date it should be black, and if it is after both it should be blue. I know this is confusing but please try to help!

[Keebellah]

You can simply add conditional formatting to do just that, instead of the value you choose the formula option and then watch your syntax. If you run Office 2007 you have more than 3 conditions so keep this in mind.