×
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

Conditional formatting

Conditional formatting

Conditional formatting

(OP)
Seems like this shouldn't be difficult but it must be bed time. Simply put...

Conditional format in cell B1....If A1 is less than zero then format text in this cell (B1) red.

Not sure how to go about this. Any thoughts?

Doug

RE: Conditional formatting

there is a number of ways. one quick way is to:
1. select B1, then choose conditional formatting
2. window pops up...select the top option "Highlight Cell rules"
3. window pops up...select "less than"
4. in next window, simply type 0 in the text box
5. then to the right of that is a drop down menu. select the bottom option "custom format"
6. change both the FONT and the FILL to red. Hit OK.
7. Hit OK again.
8. In B1 type, =A1
9. type in your number below zero.....
8. Success!!!!!!!!!

RE: Conditional formatting

just to add...when the number is zero or above, B1 will return a typical white cell with a positive number. if you wanted a blank cell, just change the font colour to white as you normally would, and you will have a "blank cell". or add a new rule to change it to green or similar. have fun!!!

RE: Conditional formatting

(OP)
Thanks for the reply. Perfect answer...Unfortunately I think I worded it wrong.sad
It should have read, if (A1) is less than zero then format (B1) red. Another way to put it would be if one cell is less than
zero then format a different one red. Would I maybe have to use a function in (B1) instead of conditional formatting?

Thanks again.

Doug

RE: Conditional formatting

I'm pretty sure conditional formatting still applies here. Sorry if im mistaken, but what you explained in your previous post still seems to be solved with my initial instruction. I must be misunderstanding you somewhere sorry.

RE: Conditional formatting

(OP)
I've got it now. Thanks.

Doug

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