Hi, I have a spreadsheet wherein i extract the minimum value per item. The Suppliers are colour coded, and I would like the result to highlight the cell with relevant customer colour code as well. Attached is an example of what I mean. I merely used cell background colour in this instance, but I am sure it requires perhaps conditional formatting. Also have used a straight forward Min function. Hope someone can assist me. Many thanks in advance.
Merle
you can use conditional formatting
and select the same colour in the format as the suppliers
then you can use a formula
=K1=C1
format that colour
then
=K1=E1
=K1=G1
=K1=I1
and apply to the column
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Please see attached file. There are formulas in Column L which you can hide.
You can review rules for Conditional Formatting by going to CF and select Manage rules.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi there,Originally Posted by etaf
This has been solved. This is in fact a macro "getmincolour". Many thanks for your input.
M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks