Soldato
- Joined
- 17 Jan 2006
- Posts
- 4,313
Hi
I'm trying to put together a fairly simple spreadsheet to keep track on the criteria I have achieved on my college course and want to be able to have a visual reference to make things easier as I need to achieve each one twice.
So far i have a list of the criteria and next to each I have two columns, which represent me having achieved the criteria once and then twice which works fine.
However for the visual reference I would like to have a cell for each criteria and have it formatted yellow if I have achieved it once and green if I've got it twice. I've worked out a way to do this using two formatting rules one OR rule which fills the cell yellow if I've filled in either of the two cells in the criteria list and an AND rule which fills the cell green if I have filled in both cells in the criteria list. This can be seen in the screen shot below
Achieved once
Achieved twice
I could individually create the two rules for each individual criteria in the top section but that would take ages and I wondered if there was an easier way, or if I could achieve the same using a single formula which would halve the amount of rules I'd need to create? Is there some kind If/Then rule I could create so If one of the criteria columns was filled in then format yellow and if both then format green?
Any help would really be appreciated.
I'm trying to put together a fairly simple spreadsheet to keep track on the criteria I have achieved on my college course and want to be able to have a visual reference to make things easier as I need to achieve each one twice.
So far i have a list of the criteria and next to each I have two columns, which represent me having achieved the criteria once and then twice which works fine.
However for the visual reference I would like to have a cell for each criteria and have it formatted yellow if I have achieved it once and green if I've got it twice. I've worked out a way to do this using two formatting rules one OR rule which fills the cell yellow if I've filled in either of the two cells in the criteria list and an AND rule which fills the cell green if I have filled in both cells in the criteria list. This can be seen in the screen shot below
Achieved once
Achieved twice
I could individually create the two rules for each individual criteria in the top section but that would take ages and I wondered if there was an easier way, or if I could achieve the same using a single formula which would halve the amount of rules I'd need to create? Is there some kind If/Then rule I could create so If one of the criteria columns was filled in then format yellow and if both then format green?
Any help would really be appreciated.
