Conditional Formating

  • Thread starter Thread starter Khalil handal
  • Start date Start date
K

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
 
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
 
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.
 
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.
 
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!!!
 
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-
 
Thanks for the help

RagDyer said:
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-
Click to expand...
 
Back
Top