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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com