and here i am once again:

i want to format a cell based on the value of another cell:

A1 - is set to 0, 1, 2, etc (0 & 2 represent a dollar amount; 1 represents a
% value)

cell A2 - describes 0 as a fixed dollar amount, 1 describes the value as a
percentage, 2 describes a fixed dollar amount also

the above i'm good at, and i have that part down.

the next part i need help with.

i want cell A3 to automatically format into a percentage or dollar based on
A1's value

if A1=0 or 2 == when i enter 6.25 in A3, i want the cell to show $6.25
if A1=1 == when i enter 6.25 in A3, i want the cell to show 6.25%

i tried conditional format, but all it really allows me to do is color the
cell.

any help will be appreciated.

jatman