Conditional Formating

[Khalil handal]

Is it possible to use conditional formatin in Excel 2003 to:
value cell is in red if it's format is accounting - Dollars
value cell is in blue if it's format is accounting - Euros

 

[CG1954]

Yes
Use "cell value is equal to" in conditional formatting.
You will have to ensure you use the required currency symbol ($ / €) as you
enter the the amount in each cell ie
$12000
€12000

CG1954

 

[Khalil Handal]

The cell are preformated as accounting: either dollars ($) or (€) .
When I enter a number in a cell it will automaticcly have the sign shown.
Of course the cells contains different values.

 

[RagDyeR]

Say A1 is formatted for $'s,
And A2 for €'s.

In B1 enter:

=Cell("format",A1)

And copy down to B2.

B1 returns < C2 >
And B2 returns < ,2 >

SO ... conditional formulas such as:

=CELL("format",A1)="C2"

And

=CELL("format",A1)=",2"

should work for you for condition 1 and condition 2 formulas set with your
colored formats.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



The cell are preformated as accounting: either dollars ($) or (€) .
When I enter a number in a cell it will automaticcly have the sign shown.
Of course the cells contains different values.

 

[Khalil Handal]

Works for some cells and doesn't work for other values in the range.
Is there anything special????
The condition is "and" in conditional formating which gives the impresion
that it sould fulfill BOTH conditions!!!

 

[RagDyer]

I don't follow what you mean when you say:
<<<"The condition is "and" in conditional formatting">>>

Use "Formula is" with
=CELL("format",A1)="C2"
for Condition1
format to Red-

Use "Formula is" with
=CELL("format",A1)=",2"
for Condition2
format to Green-

 

[RagDyer]

You're welcome, and appreciate the feed-back.

Also, check your system clock!

 

[Khalil Handal]

Thanks for the help

I don't follow what you mean when you say:
<<<"The condition is "and" in conditional formatting">>>

Use "Formula is" with
=CELL("format",A1)="C2"
for Condition1
format to Red-

Use "Formula is" with
=CELL("format",A1)=",2"
for Condition2
format to Green-