I have a excel document which has a chart of boolean values... ie 0's and 1's
All I was is something that basically looks though all the cells and if its a number 1 then it makes the bg colour Green, or if its a 0 then red... and if its not a 1 or 2 then to ignore it...
Any idea's??
I have never ever done anything advanced in excel so please explain in simple terms if this is possible
- Carl S