Formatting a cell containing text

[Closed]
Report
Posts
1
Registration date
Friday July 28, 2017
Status
Member
Last seen
July 28, 2017
-
Posts
6
Registration date
Friday July 28, 2017
Status
Member
Last seen
July 31, 2017
-
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 reply

Posts
6
Registration date
Friday July 28, 2017
Status
Member
Last seen
July 31, 2017

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.