Hi
I am working on a spreadsheet that the final values are in numbers, they should fall in a range so the cells will change color to green if it passes and red if it is failing,
Now at the top to see if the entire sheet has passes how do I tally up all the cells as I cannot say if
=IF(AND(I147="pass",D174="pass"),"pass","Fail")
as it is only the color changes depending on the number.
so how to say pass if all cells are green and fail if not?
Thanks in Advance!!!!
I am working on a spreadsheet that the final values are in numbers, they should fall in a range so the cells will change color to green if it passes and red if it is failing,
Now at the top to see if the entire sheet has passes how do I tally up all the cells as I cannot say if
=IF(AND(I147="pass",D174="pass"),"pass","Fail")
as it is only the color changes depending on the number.
so how to say pass if all cells are green and fail if not?
Thanks in Advance!!!!