Forum Statistics
- Forum Members:
- Total Threads:
- Total Posts: 8
There are 1 users currently browsing forums.
|
 |
02-05-2010, 08:42 AM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: SC
MS Office Version:Excel 2007
Posts: 8
|
|
|
Moving color coded cell with formula
Please Register to Remove these Ads
I am working on a spreadsheet that has 3 columns which are color coded. I want to find the minimum in each row and move it with its color automatically. I know how to use the MIN formula, but how do you move the color with it?
Last edited by sctwin2; 02-05-2010 at 03:54 PM.
|
02-05-2010, 12:21 PM
|
 |
Forum Moderator
|
|
Join Date: 05 Feb 2007
Location: Wisconsin, U.S.A.
MS Office Version:2007
Posts: 3,882
|
|
|
Re: Excel Formula help
Hi Sctwin, welcome to the forum.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
__________________
- Paul
Click here to read the Forum Rules
To give a virtual "pat on the back" click the  icon in the gray toolbar from that user's post.
To report abuse, spam or offensive posts, please click the  icon.
|
02-06-2010, 09:34 PM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: SC
MS Office Version:Excel 2007
Posts: 8
|
|
|
Want cell color to move with formula
Several color coded columns with number. Need to find Minimum in each row. Want color of cell to move with the minimum. How do you do it?
|
02-06-2010, 09:49 PM
|
 |
Forum Moderator
|
|
Join Date: 28 Oct 2008
Location: German in New Zealand
MS Office Version:2000 - 2010
Posts: 4,688
|
|
|
Re: Moving color coded cell with formula
What do you mean moving the minimum? Do you want to highlight the minimum value of each row? If so, select the cells, then click Conditional Formatting - New Rule - use a formula to determine
=A1=(min($A1:$C1)
and set a format
adjust ranges to suit.
|
02-06-2010, 11:16 PM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: SC
MS Office Version:Excel 2007
Posts: 8
|
|
|
Re: Moving color coded cell with formula
I am moving them to a new column.
|
02-06-2010, 11:42 PM
|
|
Forum Moderator
|
|
Join Date: 28 Oct 2008
Location: German in New Zealand
MS Office Version:2000 - 2010
Posts: 4,688
|
|
|
Re: Moving color coded cell with formula
how are you moving it? with code? post your workbook
|
02-07-2010, 07:47 AM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: SC
MS Office Version:Excel 2007
Posts: 8
|
|
|
Re: Moving color coded cell with formula
The primary column has the minimum number. Want to color to move with it.
|
02-08-2010, 01:46 PM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: SC
MS Office Version:Excel 2007
Posts: 8
|
|
|
Re: Moving color coded cell with formula
I used your formula and it worked for the first row. How do I get it to work for each row? I really wanted to move the hightlighted cell to a different column but don't think that will work.
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
