Formatting a cell containing text

Closed
markyprest Posts 1 Registration date Friday July 28, 2017 Status Member Last seen July 28, 2017 - Jul 28, 2017 at 07:04 AM
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017 - Jul 28, 2017 at 11:57 AM
I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within the other cells of the same row is greyed out. This will help signify which tasks are still active and which ones aren't. If further explanation is required please let me know.

1 response

stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017
Jul 28, 2017 at 11:57 AM
You can do this using conditional formatting.

First select the range in which you want this.

Then go to Home --> Conditional Formatting --> New Rule.

Use the below formula in conditional formatting: =IF($A1="Yes",TRUE,FALSE)

This formula assumes you have Yes/No in cell A1 (adjust according to your data). Specify the color in conditional formatting.

Now when you enter Yes in column 1, it will change the row color.
0