close

Hello
I have two colums of numbers with one number always being higher than the
other.
A B
2 3
1 4
3 1
5 0 and so on.
What I need to do is somehow change the font colour of whichever number is
highest per row. Tried conditional format but this didnot work.
Many thanks

Hi!

Try this:

Assume your data is in the range A1:B4

Select the range A1:B4
Goto Formatgt;Conditional Formatting
Formula Is: =A1=MAX($A1:$B1)
Click the Format button
Select the desired style(s)
OK out

Biff

quot;CJRollsquot; gt; wrote in message
...
gt; Hello
gt; I have two colums of numbers with one number always being higher than the
gt; other.
gt; A B
gt; 2 3
gt; 1 4
gt; 3 1
gt; 5 0 and so on.
gt; What I need to do is somehow change the font colour of whichever number is
gt; highest per row. Tried conditional format but this didnot work.
gt; Many thanks
I tried as you wrote but nothing happens. What do I need in the first drop
down boxes

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; Assume your data is in the range A1:B4
gt;
gt; Select the range A1:B4
gt; Goto Formatgt;Conditional Formatting
gt; Formula Is: =A1=MAX($A1:$B1)
gt; Click the Format button
gt; Select the desired style(s)
gt; OK out
gt;
gt; Biff
gt;
gt; quot;CJRollsquot; gt; wrote in message
gt; ...
gt; gt; Hello
gt; gt; I have two colums of numbers with one number always being higher than the
gt; gt; other.
gt; gt; A B
gt; gt; 2 3
gt; gt; 1 4
gt; gt; 3 1
gt; gt; 5 0 and so on.
gt; gt; What I need to do is somehow change the font colour of whichever number is
gt; gt; highest per row. Tried conditional format but this didnot work.
gt; gt; Many thanks
gt;
gt;
gt;

Assume your range is A1:B4

Select the range starting in cell A1 to B4. Cell A1 is the active cell. Its
background color is still white while the other cells that are selected are
quot;blueishquot;.

Goto Formatgt;Conditional Formatting
From the first drop down select Formula Is
In the box to the right enter this exact formula:

=A1=MAX($A1:$B1)

The placement of the $ signs is very important!

Click the format button
Select the style(s) desired
OK out

Biff

quot;CJRollsquot; gt; wrote in message
...
gt;I tried as you wrote but nothing happens. What do I need in the first drop
gt; down boxes
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; Assume your data is in the range A1:B4
gt;gt;
gt;gt; Select the range A1:B4
gt;gt; Goto Formatgt;Conditional Formatting
gt;gt; Formula Is: =A1=MAX($A1:$B1)
gt;gt; Click the Format button
gt;gt; Select the desired style(s)
gt;gt; OK out
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;CJRollsquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello
gt;gt; gt; I have two colums of numbers with one number always being higher than
gt;gt; gt; the
gt;gt; gt; other.
gt;gt; gt; A B
gt;gt; gt; 2 3
gt;gt; gt; 1 4
gt;gt; gt; 3 1
gt;gt; gt; 5 0 and so on.
gt;gt; gt; What I need to do is somehow change the font colour of whichever number
gt;gt; gt; is
gt;gt; gt; highest per row. Tried conditional format but this didnot work.
gt;gt; gt; Many thanks
gt;gt;
gt;gt;
gt;gt;
Exactly what I needed Biff.
Thanks very much for your persistance with my problem. Greatly appreciated

CJRolls

quot;Biffquot; wrote:

gt; Assume your range is A1:B4
gt;
gt; Select the range starting in cell A1 to B4. Cell A1 is the active cell. Its
gt; background color is still white while the other cells that are selected are
gt; quot;blueishquot;.
gt;
gt; Goto Formatgt;Conditional Formatting
gt; From the first drop down select Formula Is
gt; In the box to the right enter this exact formula:
gt;
gt; =A1=MAX($A1:$B1)
gt;
gt; The placement of the $ signs is very important!
gt;
gt; Click the format button
gt; Select the style(s) desired
gt; OK out
gt;
gt; Biff
gt;
gt; quot;CJRollsquot; gt; wrote in message
gt; ...
gt; gt;I tried as you wrote but nothing happens. What do I need in the first drop
gt; gt; down boxes
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; Try this:
gt; gt;gt;
gt; gt;gt; Assume your data is in the range A1:B4
gt; gt;gt;
gt; gt;gt; Select the range A1:B4
gt; gt;gt; Goto Formatgt;Conditional Formatting
gt; gt;gt; Formula Is: =A1=MAX($A1:$B1)
gt; gt;gt; Click the Format button
gt; gt;gt; Select the desired style(s)
gt; gt;gt; OK out
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;CJRollsquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hello
gt; gt;gt; gt; I have two colums of numbers with one number always being higher than
gt; gt;gt; gt; the
gt; gt;gt; gt; other.
gt; gt;gt; gt; A B
gt; gt;gt; gt; 2 3
gt; gt;gt; gt; 1 4
gt; gt;gt; gt; 3 1
gt; gt;gt; gt; 5 0 and so on.
gt; gt;gt; gt; What I need to do is somehow change the font colour of whichever number
gt; gt;gt; gt; is
gt; gt;gt; gt; highest per row. Tried conditional format but this didnot work.
gt; gt;gt; gt; Many thanks
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;CJRollsquot; gt; wrote in message
...
gt; Exactly what I needed Biff.
gt; Thanks very much for your persistance with my problem. Greatly appreciated
gt;
gt; CJRolls
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Assume your range is A1:B4
gt;gt;
gt;gt; Select the range starting in cell A1 to B4. Cell A1 is the active cell.
gt;gt; Its
gt;gt; background color is still white while the other cells that are selected
gt;gt; are
gt;gt; quot;blueishquot;.
gt;gt;
gt;gt; Goto Formatgt;Conditional Formatting
gt;gt; From the first drop down select Formula Is
gt;gt; In the box to the right enter this exact formula:
gt;gt;
gt;gt; =A1=MAX($A1:$B1)
gt;gt;
gt;gt; The placement of the $ signs is very important!
gt;gt;
gt;gt; Click the format button
gt;gt; Select the style(s) desired
gt;gt; OK out
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;CJRollsquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I tried as you wrote but nothing happens. What do I need in the first
gt;gt; gt;drop
gt;gt; gt; down boxes
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; Try this:
gt;gt; gt;gt;
gt;gt; gt;gt; Assume your data is in the range A1:B4
gt;gt; gt;gt;
gt;gt; gt;gt; Select the range A1:B4
gt;gt; gt;gt; Goto Formatgt;Conditional Formatting
gt;gt; gt;gt; Formula Is: =A1=MAX($A1:$B1)
gt;gt; gt;gt; Click the Format button
gt;gt; gt;gt; Select the desired style(s)
gt;gt; gt;gt; OK out
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;CJRollsquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hello
gt;gt; gt;gt; gt; I have two colums of numbers with one number always being higher
gt;gt; gt;gt; gt; than
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; other.
gt;gt; gt;gt; gt; A B
gt;gt; gt;gt; gt; 2 3
gt;gt; gt;gt; gt; 1 4
gt;gt; gt;gt; gt; 3 1
gt;gt; gt;gt; gt; 5 0 and so on.
gt;gt; gt;gt; gt; What I need to do is somehow change the font colour of whichever
gt;gt; gt;gt; gt; number
gt;gt; gt;gt; gt; is
gt;gt; gt;gt; gt; highest per row. Tried conditional format but this didnot work.
gt;gt; gt;gt; gt; Many thanks
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()