Moving color coded cell with formula

**sctwin2** · 02-05-2010, 09:42 AM

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?

**Paul** · 02-05-2010, 01:21 PM

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.

**sctwin2** · 02-06-2010, 10:34 PM

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?

**teylyn** · 02-06-2010, 10:49 PM

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.

**sctwin2** · 02-07-2010, 12:16 AM

I am moving them to a new column.

**teylyn** · 02-07-2010, 12:42 AM

how are you moving it? with code? post your workbook

**sctwin2** · 02-07-2010, 08:47 AM

The primary column has the minimum number. Want to color to move with it.

**sctwin2** · 02-08-2010, 02:46 PM

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.