You can test for conditional formatting here:
http://www.cpearson.com/excel/CFColors.htm
If you could paste an example of the spreadsheet (just a few lines) then it would be easier to imagine what you're after (though I'm a bit busy today, so I may not be able to look at it in much detail...)
@christianSpaceman started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
You can test for conditional formatting here:
http://www.cpearson.com/excel/CFColors.htm
If you could paste an example of the spreadsheet (just a few lines) then it would be easier to imagine what you're after (though I'm a bit busy today, so I may not be able to look at it in much detail...)