Hi,

I'm looking for a way to make cell values change according to other cell
values.

for example,

If Cell A1 says COLLATERAL, then D1 should say N/A.

Hope you can help
Thanx!
srain

Hi,

This is not conditional formatting ... it is just an If() function :

=IF(A1="Collateral","N/A","")

HTH

This is NOT formatting; it is the use of a function.
In D1 enter =IF(A1="COLLATERAL","N/A","XXXX")
where XXXX is what you want if A1's value is not COLLATERAL - If you want
nothing then use two double quotes with nothing inside them
=IF(A1="COLLATERAL","N/A","")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"srain001" wrote in message
...
Hi,

I'm looking for a way to make cell values change according to other cell
values.

for example,

If Cell A1 says COLLATERAL, then D1 should say N/A.

Hope you can help
Thanx!
srain