Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
price higher than...
I have developed a tool list that I wish to send to vendors in excell format.
In it I have a price colum for them to fill out. I would like to know how I can make prices higher than a particular value change font color or stand out in some other way. details: colum A-vendor name; B-description; C-quanitity; D-location; E-PRICE. can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
price higher than...
Use FormatConditional Format
HTH -- AP "Thad" a écrit dans le message de news: ... I have developed a tool list that I wish to send to vendors in excell format. In it I have a price colum for them to fill out. I would like to know how I can make prices higher than a particular value change font color or stand out in some other way. details: colum A-vendor name; B-description; C-quanitity; D-location; E-PRICE. can anyone help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
price higher than...
use conditional formatting from the format menu.
in it you can select the range (column E in your case) and under which conditions format should change. then you simply select the format you desire. TC, myra "Thad" wrote: I have developed a tool list that I wish to send to vendors in excell format. In it I have a price colum for them to fill out. I would like to know how I can make prices higher than a particular value change font color or stand out in some other way. details: colum A-vendor name; B-description; C-quanitity; D-location; E-PRICE. can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I formulate a high price column | Excel Discussion (Misc queries) | |||
Recording a high price on a worksheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions |