Conditional Format Question

S

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
 
C

Carim

Hi,

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

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

HTH
 
B

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
 
Top