Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change text colour [email protected] Charts and Charting in Excel 1 December 24th 07 09:04 AM
Change text colour according to number R.Demandt Excel Worksheet Functions 2 November 28th 06 08:24 AM
change text colour Jeff New Users to Excel 3 February 15th 06 05:53 AM
Quick Text colour change? mrrix32 Excel Discussion (Misc queries) 0 January 11th 06 04:30 PM
Change Colour OF Text??? James UK23 Excel Discussion (Misc queries) 1 May 19th 05 12:32 AM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"