|This may not be exactly what you are looking for, but see if the concept can be modified to fit your needs.|
First, if I had to type Pass or Fail next to 235 computer names, the first thing I would do is automate the entry of the text.
Put these 2 macros in the VBA editor:
Selection.FormulaR1C1 = "Pass"
Selection.FormulaR1C1 = "Fail"
Then use Tools...Customize...Commands tab...Macros and drag a 2 Custom Buttons or Custom Menu Items up to a toolbar.
With the Customize dialog box still open, right click the item and edit one to say Pass and the other to say Fail.
Right click them again and choose Assign macro and assign each button the appropriate macro.
Close the Customize dialog box.
Now you can select any cell and click the appropriate button to put the text in the cell.
Next, now that you got a bunch of cells that say Pass or Fail you could use COUNTIF and COUNTA to create a percentage, e.g. in C1 put:
Once you have this number, use Conditional Formatting to color your cells, based on your percentage criteria,
e.g. using 30% and 70% as my breakpoints:
Condition 1...Formula Is...=C1<=.3
Condition 2...Formula Is ...=IF(AND(C1>.3,C1<.7),TRUE,FALSE)
Condition 3...Formula Is...=C1>=.7
I hope that points you in the right direction.