Conditional formatting of cell based on text in another cell - help the newb please...

Hi guys,

I tried searching around but couldn't find an answer for this problem.

First time here. I suck at excel but I need to get better because I'm using it more and more.
I'm making a template sheet for purchase orders. The orders come from many countries so the currencies vary.
I want to be able to select a currency from a drop down list, and this will automatically format a bunch of other cells.
Example: I select USD and the other cells are formatted thusly - "$0.00".

I tried to write a formula for a conditional formatting "rule" - but it ain't working.
This is the first time I've tried using an "IF" statement, so I probably buggered it up.

I have attached a sample of the worksheet, and a screen shot of my "rule" with the formula.
I have only tried to format for Japanese ¥ so far. If I can get that to work I'll add rules for the other currencies.

Any help much appreciated.

Dan



(I'm on an old 2012 Macbook pro, running Mojave, with a subscription to Office 365. Excel version 16.51 apparently)

Hi
the IF function is implicit in Conditional Formatting and thus redundant
If you don't have too many currencies enter =$C$4="JPY" and format as required (Number - Currency - and select the Currency.
Then add as many new conditions as necessary always based on the same type of rule. (e.g. =$C$4="USD")

Hey Pepe,
Thanks for your help buddy, problem solved!

I have a couple of conditions which result in the same format.
Is it possible to combine into 1 x rule? Is there some kind of "OR" function in excel?
I tried =$C$4="NTD" OR =$C$4="HKD" but the rule manager won't except it as a formula.
I'm assuming the less rules the better....

Kick-***!
Thanks Rorya.
Gotta say - I'm loving this forum already.

Ok - so my template is looking good and working well.
I can't seem to find a way to create new sheets from a template.
If I right click on the sheet tabs there is no option, nor on the "+" tab. Am I missing something?
I can make new workbooks from a template, but that's not that useful. I want 1 x workbook with all my purchase order sheets in it.
If I make a new workbook from the template, and then move the sheet to the correct workbook, my data validation references all stop working.
Perhaps I just keep a template sheet in the workbook and make copies from it....

BTW you do not need to use formula with the OR function, you have to create separate rules for each currency which will then format accordingly
Using the OR function will only allow 1 formatting

Originally Posted by AliGW

This is a completely different question. Please mark this thread as solved and start a new thread with an appropriate title. Thanks.

Ah- no problem. New here, not aware of the protocols.
I'll mark this one as solved. Cheers.