Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency conditional formatting
I have some columns that I want to format currency based on currency figures
in the column cells. Lets say Cell A2 = 1, B2 = 1.30, cell D2= 1.7 How do I make these figures be conditionally formatted so that cell A2 can be = USD 1.00, cell B2 = EUR 1.30 and Cell D2 = GBP 1.7 - Where USD = 1.00, Eur = 1.30, GBP = 1.7. I use Excel 2007. All help totally appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Currency | Excel Worksheet Functions | |||
Conditional formatting - currency? | Excel Programming | |||
Conditional Formatting Problem with currency. | Excel Programming | |||
conditional formatting for currency | Excel Worksheet Functions | |||
Conditional Formatting for Currency | Excel Programming |