Conditional formatting for not equal to situation

**ROHAN999** · 07-06-2013, 02:28 AM

I want to use conditional formatting..such as if in my column c any cell is not "approved"_(this text is not there in any cell of column c).

Then that entire row should become yellow

kindly help in formula based condtional formatting..but not getting correct formula or condition to put..

**AndyLitch** · 07-06-2013, 02:35 AM

1. Select the cells you want formatting.
2. Make a note of the top left cell address.......... e.g. C15 in this example
3. Select Conditional Formatting.
4. Select "Use a formula"
5. In the formula bar enter =$C15=""
6. Set the format
7. Select OK

Note the $ sign is critical in making the whole row dependant on the value in C15

**dilipandey** · 07-06-2013, 02:51 AM

Hi Rohan,

see the attached file where I have applied the conditional formatting from row 1 to row 10 :-

cf for entire row.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**ROHAN999** · 07-06-2013, 03:32 AM

Very nice thank you

<> worked

**ROHAN999** · 07-06-2013, 03:33 AM

Nice to see you again dilip ji..

Proud indian

**dilipandey** · 07-06-2013, 03:46 AM

You are welcome Rohan

Cheers

Regards,
DILIPandey
<click on below * if this helps>

Conditional formatting for not equal to situation

LinkBack

Thread Tools

Rate This Thread

Display

Conditional formatting for not equal to situation

Re: Conditional formatting for not equal to situation

Re: Conditional formatting for not equal to situation

Re: Conditional formatting for not equal to situation

Re: Conditional formatting for not equal to situation

Re: Conditional formatting for not equal to situation

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions