Get value from the adjacent cell
Solved/Closed
Related:
- Get value from the adjacent cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
4 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 23, 2010 at 09:56 AM
Jun 23, 2010 at 09:56 AM
Could you please upload a sample file with sample data, CONDITIONAL FORMAT , MACRO, formula etc on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
hI,
Thks for ur response...pls find below a more detailed description of my problem...
DATE DAY APPLE GRAPE ORANGE
14/6 Mon 46.57 56.81 68.23
15/6 Tue 46.73 56.92 68.67
16/6 Wed 46.35 57.16 68.67
17/6 Thu 46.50 57.09 68.36
18/6 Fri 46.14 57.18 68.46
21/6 Mon 45.64 56.83 68.06
i need to highlight/background colour of the maximum value in APPLE column and other columns respectively
Date Price
High 15/6 46.31 =Max(C2:C7)
Low 21/7 45.64 =Min(C2:C7)
maximum value in the apple column is 46.73 so I need to get the date which is 15/6. The max value changes based on the input in column.
Await ur reply...
Thks for ur response...pls find below a more detailed description of my problem...
DATE DAY APPLE GRAPE ORANGE
14/6 Mon 46.57 56.81 68.23
15/6 Tue 46.73 56.92 68.67
16/6 Wed 46.35 57.16 68.67
17/6 Thu 46.50 57.09 68.36
18/6 Fri 46.14 57.18 68.46
21/6 Mon 45.64 56.83 68.06
i need to highlight/background colour of the maximum value in APPLE column and other columns respectively
Date Price
High 15/6 46.31 =Max(C2:C7)
Low 21/7 45.64 =Min(C2:C7)
maximum value in the apple column is 46.73 so I need to get the date which is 15/6. The max value changes based on the input in column.
Await ur reply...
Hi,
Thks for ur response.....i hv mentioned below the problem in more detail....
DATE---DAY----Apple----Orange----Grape
14/6 Mon 1 6 3
15/6 Tue 3 9 4
16/6 Wed 4 2 5
17/6 Thu 5 8 6
18/6 Fri 8 6 9
21/6 Mon 5 3 8
I'm trying to create a excel worksheet that highlights by changing the background colour of the maximum value in the apple, Orange & Grape column . The max value changes based on the input in another column.
I had come across this formula =MAX(IF(NOT(ISNA(C2:C7)),C2:C7)) but I dont seem to be getting the desired answer.
Secondly, I need to get the date that corresponds with the maximum value that is located in the column to the left.
Date Price
High-------18/6--------8 =MAX(C2:C7)
Low--------14/6-------1 =MIN(C2:C7)
I was trying VLOOKUP but again not getting the desired answer.
I look forward to your reply...
Thks for ur response.....i hv mentioned below the problem in more detail....
DATE---DAY----Apple----Orange----Grape
14/6 Mon 1 6 3
15/6 Tue 3 9 4
16/6 Wed 4 2 5
17/6 Thu 5 8 6
18/6 Fri 8 6 9
21/6 Mon 5 3 8
I'm trying to create a excel worksheet that highlights by changing the background colour of the maximum value in the apple, Orange & Grape column . The max value changes based on the input in another column.
I had come across this formula =MAX(IF(NOT(ISNA(C2:C7)),C2:C7)) but I dont seem to be getting the desired answer.
Secondly, I need to get the date that corresponds with the maximum value that is located in the column to the left.
Date Price
High-------18/6--------8 =MAX(C2:C7)
Low--------14/6-------1 =MIN(C2:C7)
I was trying VLOOKUP but again not getting the desired answer.
I look forward to your reply...
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 28, 2010 at 05:27 AM
Jun 28, 2010 at 05:27 AM
If all you want is to highlight in your table for each column the maximum value in that column, then you can use conditional format
based on your sample data
click on j5 and select from J5 till L20
now goto conditional formatting and enter this formula
=J5=MAX(j$5:J$20)
and then click on the format button of conditional formatting and chose the color
for date you can use this formula (this is for e41)
=INDIRECT("H" &MATCH(F41,J:J,0))
this is for j41
=INDIRECT("H" &MATCH(K41,K:k,0))
based on your sample data
click on j5 and select from J5 till L20
now goto conditional formatting and enter this formula
=J5=MAX(j$5:J$20)
and then click on the format button of conditional formatting and chose the color
for date you can use this formula (this is for e41)
=INDIRECT("H" &MATCH(F41,J:J,0))
this is for j41
=INDIRECT("H" &MATCH(K41,K:k,0))
Jun 24, 2010 at 03:14 AM
Thks for ur response.....i hv mentioned below the problem in more detail....
DATE DAY Apple Orange Grape
14/6 Mon 1 6 3
15/6 Tue 3 9 4
16/6 Wed 4 2 5
17/6 Thu 5 8 6
18/6 Fri 8 6 9
21/6 Mon 5 3 8
I'm trying to create a excel worksheet that highlights by changing the background colour of the maximum value in the apple, Orange & Grape column . The max value changes based on the input in another column.
I had come across this formula =MAX(IF(NOT(ISNA(C2:C7)),C2:C7)) but I dont seem to be getting the desired answer.
Secondly, I need to get the date that corresponds with the maximum value that is located in the column to the left.
Date Price
High 8 =MAX(C2:C7)
Low 1 =MIN(C2:C7)
I was trying VLOOKUP but again not getting the desired answer.
I look forward to your reply...
Jun 24, 2010 at 06:48 PM
Could you add an EXCEL file at any share site and post back the link, Please show in that book how the data is NOW AND how would you like that the final product to look like.
Jun 28, 2010 at 04:48 AM
https://authentification.site/files/23162922/rate_ref.xls
Look forward to your solutions
Jun 28, 2010 at 08:09 AM