View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shoulder Shoulder is offline
external usenet poster
 
Posts: 2
Default Adding Numbers and Changing colors

I am brand new to this so please be as basic as you can be. I have a couple
of questions. I hope you can help me with.

1) F3 is at a value of 10
I want H2 ( at a value of 2) to subtract from F3 and now have it read 8.

2) I want I3 to add up old H3 to the new H3 that is entered to give a total.

3) I want F3 to turn red when = to or less than G3. I tried format
conditional formatting but F3 stays red all the time. How do I fix this?