I'd write a helper column, so that something like: if a1 = condition 1 then 1 else if a1 = condition 2 then 2
etc etc then you can colour the account cell based on the helper cell and also filter / sum/whatever based on the helper.
@Chalfie 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.
I'd write a helper column, so that something like:
if a1 = condition 1 then 1
else
if a1 = condition 2 then 2
etc etc
then you can colour the account cell based on the helper cell and also filter / sum/whatever based on the helper.