Forum Discussion
Cell Colour Changed Based On Two Values
Hello, I have a query… A1 could contain either the text ‘Team One’ or ‘Team Two’. B1 will contain a number. I want the colour of B1 to change, dependant firstly on what Text is in A1 and ...
Hi TheLifeOfJon
The 1st rule is:
=AND($A1="Team One", $B1 >=0, $B1 <=12)once you've understood it, the others should be easy to set up - sample attached