Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Text Colour Of Lowest Value
Hi,
Below is a list of numbers and i need the lowest number of each row to show up as red text. ie first row i want 36 to turn red, second row 2 to turn red. Please could someone help???? 36 37 38 12 93 2 85 48 21 2 52 5 32 5 6 21 12 5 12 1123 51 -- Jonno |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Text Colour Of Lowest Value
hi
you can use conditional formating for this.. select cell A2 (or whatever you wish) on the menu bar... formatcoditional format. Formula is......=A2=MIN(2:2).....pick your format. then copy A2 and paste as formats across row 2 as far as you need. this conditional format will look at all data in row 2 only. you can then past as formats across row 3 and so on and the lowest value in the row will be high lighted with your selected format. Regards FSt1 "Jonno" wrote: Hi, Below is a list of numbers and i need the lowest number of each row to show up as red text. ie first row i want 36 to turn red, second row 2 to turn red. Please could someone help???? 36 37 38 12 93 2 85 48 21 2 52 5 32 5 6 21 12 5 12 1123 51 -- Jonno |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Text Colour Of Lowest Value
Select A1 to C7, with the focus on A1 (colored white).
Then, from the Menu Bar: <Format <Conditional Formatting Change "Cell Value Is" to "Formula Is", and enter: =AND(A1=MIN($A1:$C1),A1<"") Then, click on "Format" and choose your Red font, Then <OK <OK, And you should be done! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jonno" wrote in message ... Hi, Below is a list of numbers and i need the lowest number of each row to show up as red text. ie first row i want 36 to turn red, second row 2 to turn red. Please could someone help???? 36 37 38 12 93 2 85 48 21 2 52 5 32 5 6 21 12 5 12 1123 51 -- Jonno |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Text Colour Of Lowest Value
This worked perfect thank you very much
-- Jonno "RagDyeR" wrote: Select A1 to C7, with the focus on A1 (colored white). Then, from the Menu Bar: <Format <Conditional Formatting Change "Cell Value Is" to "Formula Is", and enter: =AND(A1=MIN($A1:$C1),A1<"") Then, click on "Format" and choose your Red font, Then <OK <OK, And you should be done! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jonno" wrote in message ... Hi, Below is a list of numbers and i need the lowest number of each row to show up as red text. ie first row i want 36 to turn red, second row 2 to turn red. Please could someone help???? 36 37 38 12 93 2 85 48 21 2 52 5 32 5 6 21 12 5 12 1123 51 -- Jonno |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Text Colour Of Lowest Value
You're very welcome, and your feed-back is appreciated.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jonno" wrote in message ... This worked perfect thank you very much -- Jonno "RagDyeR" wrote: Select A1 to C7, with the focus on A1 (colored white). Then, from the Menu Bar: <Format <Conditional Formatting Change "Cell Value Is" to "Formula Is", and enter: =AND(A1=MIN($A1:$C1),A1<"") Then, click on "Format" and choose your Red font, Then <OK <OK, And you should be done! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jonno" wrote in message ... Hi, Below is a list of numbers and i need the lowest number of each row to show up as red text. ie first row i want 36 to turn red, second row 2 to turn red. Please could someone help???? 36 37 38 12 93 2 85 48 21 2 52 5 32 5 6 21 12 5 12 1123 51 -- Jonno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change text colour | Charts and Charting in Excel | |||
Change text colour according to number | Excel Worksheet Functions | |||
change text colour | New Users to Excel | |||
Quick Text colour change? | Excel Discussion (Misc queries) | |||
Change Colour OF Text??? | Excel Discussion (Misc queries) |