B
Bob
Hi,
I am trying to change the background colour of a cell based on another
cells value.
For instance,
Column E allows numbers 1,2,3,4,5 or 6
Column F has a nested IF formula
=IF((E276=1),"Opportunity",IF((E276=2),"WIP",IF((E276=3),"Submitted",IF((E276=4),"Approved",IF((E276=5),"Committed",IF((E276=6),"Settled",""))))))
If a cell in E column has the value "6" I want the adjacent cell in
column F ( or the whole row) to change colour to Green.
I managed to do this with a Select Case in vba before I created the
Nested IF but now the cell doesn't actually contain the word "Settled",
it contains a formula.
Any help greatly appreciated
Bob
I am trying to change the background colour of a cell based on another
cells value.
For instance,
Column E allows numbers 1,2,3,4,5 or 6
Column F has a nested IF formula
=IF((E276=1),"Opportunity",IF((E276=2),"WIP",IF((E276=3),"Submitted",IF((E276=4),"Approved",IF((E276=5),"Committed",IF((E276=6),"Settled",""))))))
If a cell in E column has the value "6" I want the adjacent cell in
column F ( or the whole row) to change colour to Green.
I managed to do this with a Select Case in vba before I created the
Nested IF but now the cell doesn't actually contain the word "Settled",
it contains a formula.
Any help greatly appreciated
Bob