J
Jaydubs
--
** Fool on the hill **
** Fool on the hill **
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
=MAX(1:1)
J
Jaydubs
That is not what I am looking for, sorry. Unfortunately it makes the entire
line green if I use this instead of the one entry in the line that is the
highest in that row.
line green if I use this instead of the one entry in the line that is the
highest in that row.
S
Sloth
sounds like you are using conditional formatting to highlight the maximum in
a list. Highlight the list and select Format->Conditional Formatting.
Select "Formula is" and use this formula
=MAX(1:1)=A1
1:1 is the list range of the list, and A1 is the left most cell in the
highlighted range. Be sure to include both equal signs. Then select the
formatting you want.
a list. Highlight the list and select Format->Conditional Formatting.
Select "Formula is" and use this formula
=MAX(1:1)=A1
1:1 is the list range of the list, and A1 is the left most cell in the
highlighted range. Be sure to include both equal signs. Then select the
formatting you want.
J
Jaydubs
The original solution did work in fact. I did use formula and than the
solution from Niek. But it should be value is equal to using Niek's solution
and it works.
Thanks everyone !!
solution from Niek. But it should be value is equal to using Niek's solution
and it works.
Thanks everyone !!