Struggling: How to do conditional formatting based on the formatting of another cell on the same row

[ibddude]

Hello all; Here is the problem: I have a column showing different types of currency so A1 could show "USD", A2, "GBP", A3, "JPY" etc. in adjacent column I want the format of the value to reflect the type of currency, "$" for USD, "Pound sing" for GBP, etc. Sounds easy enough but I can't get the right formula, this is what I tried: an example rule would be: =IF($A2 = "USD", TRUE,FALSE) and then I set the format to be "$" and then in the Range for the column of values I want to reflect this would be =$B$2:$B$9999 It works but references $A2 on every subsequent row, I need the value to increment so on the next row it looks at $A3 and so on. Any insights on how to do this would be deeply appreciated! Thanks ibddude

 

[General Ledger]

I would suggest you start by only selecting the single cell on which you want to apply the Conditional Formatting. Enter the formula and apply the currency formatting. After you get this to work fine, copy the Conditional Formatting to the other cells. Do this by using the Format Painter on the Home tab of the Ribbon.

Best of luck,

G/L