×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Need Conditional Formatting help please

Need Conditional Formatting help please

Need Conditional Formatting help please

(OP)
I have a range of cells D27:MM28
Almost all of these have the text MWZ-6006 but a handful of them have something else.

I would like to use the conditional formatting formula so that if a cell does not say MWZ-6006, the font will become red.

Can anyone please tell me what that formula is?

RE: Need Conditional Formatting help please

Hello,

select the cells, select CONDITIONAL FORMATTING and select Cell Value is, NOT EQUAL TO, MWZ-6006, format as required.

----------------------------------
Hope this helps.
----------------------------------

been away for quite a while
but am now back

RE: Need Conditional Formatting help please

Use "not equal to" MWZ-6006 and format the font to be red.

Good luck,
Latexman

To a ChE, the glass is always full - 1/2 air and 1/2 water.

RE: Need Conditional Formatting help please

(OP)
Wow was that easy. I had selected by formula and was trying to figure how to write it that way. lol

Thanks

RE: Need Conditional Formatting help please

Specifically...

=D27<>"MWZ-6006"


The rule for a CF formula is to reference with respect to the TOP LEFT cell of the selected range, which in this instance is D27 for the range, D27:MM28.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close