Get value from the adjacent cell
[Solved/Closed]
Related:
- Get value from the adjacent cell
- Merge adjacent cells in columns with same data/value in excel vba - Forum - Excel
- Cell input to call macro in adjacent cell - How-To - Excel
- Place specfic text in cell based on text in an adjacent cell ✓ - Forum - Excel
- Adding two non-adjacent cells (number and text) ✓ - Forum - Excel
- Write text in adjacent cells if one cell value is ___? ✓ - Forum - Excel
4 replies
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
Ninz
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...
Ninz
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
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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))
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...
- Posts
-
4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
768Could 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.
https://authentification.site/files/23162922/rate_ref.xls
Look forward to your solutions