×
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

Change a cell color based on the number in the cell

Change a cell color based on the number in the cell

Change a cell color based on the number in the cell

(OP)
I'd like to paste a set of data (an array of data) to a worksheet and have it automatically change the color in each cell of the  worksheet to show pass fail and close to spec. i.e. a quick color chart.

Hence a large table of measured data in one worksheet can be compared to the spec. worksheet and color the data worksheet from green to yellow to red depending on the measured data.

I could subtract the two worksheets and form a delta worksheet compared to spec and then have the colors change on that worksheet. Either is ok.   

I searched this sight for this, but didn't see any.

appreciate any hints.
Thanks.

RE: Change a cell color based on the number in the cell

Have you tried "Conditional Formatting"?  I think it is designed to do exactly what you described.

David

RE: Change a cell color based on the number in the cell

(OP)
Thanks, that works correctly, but in using a formula (data-spec), it seems that I need to do that individually for every single cell that I want the data set to show the color.

I know that I can copy formatting from one cell to the next, but I'd like the formula for conditional formatting to increment from cell to cell.  i.e. if I do conditional formatting on one cell as;
=(data A1-specA100)>0 (format color background of cell A1 to green)

then I'd like to copy and paste it so that the pasted formatting for data in cell Z1 compared to spec in cell Z100 becomes =(dataZ1-spec Z100)>0 (format color background of A1 to green).

Also, seems I can only do one color at a time, i.e. pick a green for passing or red for failing for the whole data set. i.e. can't have two colors in the resulting formatting.

At least not yet anyhow.

thanks for the hint, helped.  

RE: Change a cell color based on the number in the cell

(OP)
found it, thanks for the tips.
This formatting changes alot from 2003 to 2007 to 2010 Excel, at least the view of the menu's change alot.
 

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