Color coding to cells in columns with specific text

Hi all,

I am preparing a document for a few test cases. where in Each test case has three columns commonly.
suppose we have the columns titled 'PASS', 'FAIL' and 'Not applicable'available for each test case.

Now I want to have a Conditional formatting formula that acts as below:
1. When a cell under the column 'PASS' for any test case is filled with ANY TEXT, It should be Filled in 'Green' color.
2. When a cell under the column 'FAIL' for any test case is filled with ANY TEXT, It should be Filled in 'RED' color.
3. And when a cell under the column 'Not applicable' for any test case is filled with ANY TEXT, It should be Filled in 'Grey' color.

Also in point '2' and '3', Once any text is entered, I need a cell from another column (titled 'comments') of the same row to be filled with the same color as the result (i.e. Fail or Not applicable)

My question is, Is this possible to have it this way. If so, How can I do that?

And if this is achievable, will deleting the entered text revert the cell back to plain format (white filled and without any text).

Please kindly let me know of the possible solutions and help me with this.

Thanks...

Originally Posted by wenqq3

Attachment 227587

use conditional formatting.

At
column A(PASS):Cells that contain "NO BLANK", green
column B(FAIL):Cells that contain "NO BLANK", red
column C(Not applicable):Cells that contain "NO BLANK", grey
column D(Comments): Formula = B2 <>"", red & C2 <>"",gey (expend it by scroll down)

Hope it help

That did help.
One more query though...
How do i remove the red filling from the comments column once i enter a comment in that cell (with the Fail and Not applicable) parts untouched

Bingo!!!