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.

Formatting a cell containing text
Clear only the formatting from the selected cell (leaving the content) - Guide
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Phone formatting software for pc - Download - File management
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum

1 response

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.

Similar discussions

Highlight cell if another cell contains specific text

Hello,

I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 has 'n/a'. Any suggestions for which formula to use?

Any help would be greatly appreciated!

If a cell contains any text then add a value

I hope someone can help me with this...I've done this before but can't remember how.

I have a list of names (for an attendees list) and I need to show an extended total for each
person and the number of guests they will bring. Here's the layout...

B2 is the person's name
C2 is the number of guests they will bring
D2 is the total for that person (including them)

I need a formula that says: If B2 has any text, then add a value of "1" to C2 and enter the total in D2.

Hope that makes sense. Thank you in advance for helping.

help me to add particular cells

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

How to use conditional format based on text?

Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?

Condition formatting on changing cell color based on another cel

hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text.

For example I have cell A1 with Text Pass. Cell A1 already has conditional formatting for text "PASS" = cell color green, and text "FAIL" = cell color red. On the other hand, I have cell A2 which has some details in it and already contains a formula. I want to base A2's cell color with A1. If A1 = PASS and A1 cell color is green, then A2 cell color will be Green too. If A1 = FAIL and A1 cell color is Red, the A2 will cell color will be Red too.

Hope the description is not complicated. Thanks in advance for any advice given.

Similar discussions

Subscribe To Our Newsletter!