Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 05, 06:22 AM posted to microsoft.public.excel.worksheet.functions
Trying To Excel
 
Posts: n/a
Default Conditional Formating

I am looking for the best price to make a purchase.
A B C
Product 5 6 7

I would like to choose lowest price by changing it to a red font

  #2   Report Post  
Old December 9th 05, 06:32 AM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Conditional Formating

Assume the values are in A1:C1

select A1:C1 with A1 as active (if you select from A1 it will be active)

formatconditional formatting, formula is

=A1=MIN($A$1:$C$1)

click format and select red font, click OK twice

--
Regards,

Peo Sjoblom

(No private emails please)


"Trying To Excel" wrote in message
...
I am looking for the best price to make a purchase.
A B C
Product 5 6 7

I would like to choose lowest price by changing it to a red font


  #3   Report Post  
Old December 9th 05, 06:56 AM posted to microsoft.public.excel.worksheet.functions
Trying To Excel
 
Posts: n/a
Default Conditional Formating

Works Great,Thanks

"Peo Sjoblom" wrote:

Assume the values are in A1:C1

select A1:C1 with A1 as active (if you select from A1 it will be active)

formatconditional formatting, formula is

=A1=MIN($A$1:$C$1)

click format and select red font, click OK twice

--
Regards,

Peo Sjoblom

(No private emails please)


"Trying To Excel" wrote in message
...
I am looking for the best price to make a purchase.
A B C
Product 5 6 7

I would like to choose lowest price by changing it to a red font



  #4   Report Post  
Old December 9th 05, 07:20 AM posted to microsoft.public.excel.worksheet.functions
Trying To Excel
 
Posts: n/a
Default Conditional Formating

Can You also tell me how to make this apply to numerous products

"Peo Sjoblom" wrote:

Assume the values are in A1:C1

select A1:C1 with A1 as active (if you select from A1 it will be active)

formatconditional formatting, formula is

=A1=MIN($A$1:$C$1)

click format and select red font, click OK twice

--
Regards,

Peo Sjoblom

(No private emails please)


"Trying To Excel" wrote in message
...
I am looking for the best price to make a purchase.
A B C
Product 5 6 7

I would like to choose lowest price by changing it to a red font





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
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 06:49 PM
Conditional formating using formulas arifnj Excel Worksheet Functions 4 October 27th 05 01:56 PM
can i freeze conditional formating to copy to another worksheet Chris Lane Excel Discussion (Misc queries) 1 October 12th 05 06:53 PM
VLOOKUP & Conditional Formating Help. Excel'ed Failures Excel Discussion (Misc queries) 6 August 16th 05 04:46 PM
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 10:12 PM


All times are GMT +1. The time now is 02:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017