Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Excel question, conditional formatting (or another way)

exdragon
Resolved

Likes # 0

Posted January 15, 2013 at 3:38PM

Hi - I have a spreadsheet with data in columns A - J and thousands of rows. I want to highlight a particular row if I put the word 'no' into any cell in column B, in any row.

I don't want to just fill the individual cell and I only want the highlight to go from A to J. I've tried various examples of conditional formatting but I'm not getting what I want.

Could someone point me in the right direction, please? It's Excel 2007.

Like this post
tasslehoff burrfoot

Likes # 0

Posted January 18, 2013 at 10:07PM

"I want to highlight a particular row if I put the word 'no' into any cell in column B, in any row"

Always the same row, no matter in which row the 'no' is entered?

Like this post
exdragon

Likes # 0

Posted January 19, 2013 at 3:02PM

It's whatever row I put 'no' in - so if it's in rows 256, 1026 and 1069, I'd like to have each of those rows highlighted.

Like this post
TonyV

Likes # 0

Posted January 19, 2013 at 3:53PM

exdragon

Have a look here. Conditional Format in Excel 2007

TonyV

Like this post  

Likes # 0

Posted January 20, 2013 at 10:54AM

TonyV - you're a star, it worked a treat once I scrolled down to see that, if I wanted to use a word rather than a number, I had to use "no" rather than just no in the formula.

Many thanks.

Like this post
TonyV

Likes # 0

Posted January 20, 2013 at 8:11PM

exdragon

Glad you were able to make use of it. It was certainly a useful site to look at. You are right, when you refer to text, you need the " ".

Cheers

TonyV

Like this post
exdragon

Likes # 0

Posted January 20, 2013 at 8:38PM

I'll bookmark it!

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.