Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |