Previous Topic Next Topic

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 reply

Answer 1 / 1
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting with multiple rules and blank text cells
PaiviM -
PaiviM -

6 responses