Search results for query: *

It is set to automatic calculate. I tried F9 even though it is on automatic and nothing happens.

OK, I got it to work, but can only get it to re-calculate when I am in the vba code and use F5. The people who will use this spreadsheet are even less Excel-savvy than I am. How can I get it to re-calculate from the Excel sheet itself? Thanks.

I believe the code you are asking for is posted above on the original submittal. The formulas in the cells (B19:AF25) are a nested IF statement that refers to another cell's inputted value. The displayed number in the cell is supposed to change its color, but since you set me straight on a...

1)If what you mean by worksheet calculate is the F9 key, I tried it and nothing changed. 2)The cell values do physically change (but not the color) when I enter a new value in another cell that is referenced in the formula of the cell that I am trying to change color. 3) Not sure what you...

I know this has been discussed at length in other threads but I did not find the problem I am having. I have used the code that allows direct entry of a value into a cell which causes the formatting to change, but it does not work when that cell's value is generated by a FORMULA. Here's the...

I know this has been discussed at length in other threads but I did not find the problem I am having. I have used the code that allows direct entry of a value into a cell which causes the formatting to change, but it does not work when that cell's value is generated by a FORMULA. In the code I...