whats wrong with this ??

[Simon]

Just testing an IF statement

=IF(E1=0,C1=50,C1=20)

C1 remains BLANK regardless of value of E1

what I actually want to do is change the Background or forground colour of a
cell depending on a value in another cell !

 

[Frank Kabel]

Hi
a formula can't change a different cell. You have to put this formula
in cell C1:
=IF(E1=0,50,20)

 

[crispbd]

::whats wrong with this ??
--------------------------------------------------------------------------------
Just testing an IF statement
=IF(E1=0,C1=50,C1=20)
C1 remains BLANK regardless of value of E1
what I actually want to do is change the Background or forground colou
of a
cell depending on a value in another cell !::


Using the worksheet IF statement doesnt allow you to change a targe
cell value(only the active cell of the formula gets a value assigne
from the function)

 

[dcronje]

The formula needs to be in C1 and would look like this:

=If(E1=0,50,20)

If you are looking at formatting the best option is to use Conditiona
Formatting under the Format menu

 

[bigwheel]

If you put this formula in C1, changes will occur when E1 changes:-

=IF(E1=0,50,20)

To change colours in a cell, checkout "Conditional Formatting"