View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
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