Hello, I have a little question , on how do I highlight a certain cell like for example.
<tbody>
</tbody>as you can see table above, if the value contains "1" , the names (first,middle,last) should be highlighted.
Can anyone help me, because I am new in conditional formatting... Im out of guesting formula.. ^^
A | B | C | D | |
1 | FIRST NAME | MIDDLE NAME | LAST NAME | VALUE |
2 | JOHN | DANER | CANRES | 1 |
<tbody>
</tbody>
Can anyone help me, because I am new in conditional formatting... Im out of guesting formula.. ^^