lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi I want to format (change the color) of any row which has word "left" in the second column.
I highlighted everything and went to CF-->Formula and wrote this formula
=A1="left"
But that only highlighted the cell in 3rd column which has value = left. I want to highlight the whole row (3 cells). Thank you.
<tbody>
</tbody>
I highlighted everything and went to CF-->Formula and wrote this formula
=A1="left"
But that only highlighted the cell in 3rd column which has value = left. I want to highlight the whole row (3 cells). Thank you.
name | dept | salary |
jim | it | 100 |
alex | hr | left |
mary | sales | 50 |
dan | marketing | left |
<tbody>
</tbody>