Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting or formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting or formula
Hi!
Try this: Assume your data is in the range A1:B4 Select the range A1:B4 Goto FormatConditional Formatting Formula Is: =A1=MAX($A1:$B1) Click the Format button Select the desired style(s) OK out Biff "CJRolls" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting or formula
I tried as you wrote but nothing happens. What do I need in the first drop
down boxes "Biff" wrote: Hi! Try this: Assume your data is in the range A1:B4 Select the range A1:B4 Goto FormatConditional Formatting Formula Is: =A1=MAX($A1:$B1) Click the Format button Select the desired style(s) OK out Biff "CJRolls" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting or formula
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 "blueish". Goto FormatConditional 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 "CJRolls" wrote in message ... I tried as you wrote but nothing happens. What do I need in the first drop down boxes "Biff" wrote: Hi! Try this: Assume your data is in the range A1:B4 Select the range A1:B4 Goto FormatConditional Formatting Formula Is: =A1=MAX($A1:$B1) Click the Format button Select the desired style(s) OK out Biff "CJRolls" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting or formula
Exactly what I needed Biff.
Thanks very much for your persistance with my problem. Greatly appreciated CJRolls "Biff" wrote: 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 "blueish". Goto FormatConditional 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 "CJRolls" wrote in message ... I tried as you wrote but nothing happens. What do I need in the first drop down boxes "Biff" wrote: Hi! Try this: Assume your data is in the range A1:B4 Select the range A1:B4 Goto FormatConditional Formatting Formula Is: =A1=MAX($A1:$B1) Click the Format button Select the desired style(s) OK out Biff "CJRolls" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting or formula
You're welcome. Thanks for the feedback!
Biff "CJRolls" wrote in message ... Exactly what I needed Biff. Thanks very much for your persistance with my problem. Greatly appreciated CJRolls "Biff" wrote: 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 "blueish". Goto FormatConditional 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 "CJRolls" wrote in message ... I tried as you wrote but nothing happens. What do I need in the first drop down boxes "Biff" wrote: Hi! Try this: Assume your data is in the range A1:B4 Select the range A1:B4 Goto FormatConditional Formatting Formula Is: =A1=MAX($A1:$B1) Click the Format button Select the desired style(s) OK out Biff "CJRolls" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Conditional Formatting based on Formula | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |