Conditional Format Question

[srain001]

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

 

[Carim]

Hi,

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

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

HTH

 

[Bernard Liengme]

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