Changing a value

Closed
Mukoni - Feb 15, 2010 at 09:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 15, 2010 at 09:27 AM
Hello,

I am trying to get excel to change the value in a cell eg if cell a1 <b2 then red, if a1 > b2 green else amber.

Regards

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 15, 2010 at 09:27 AM
lets say that you want to change the value in cell c1

then you can write in c1
=IF(a1<b2, "red",if(a1>b2,"green", "amber"))
1