Replies

Thanks

You’re right, thanks. I had it in mind C3 all along. And of course, that is what I put into the formula and the code. The code was a quickie and it shows.

Tough to change an old person!

BTW, Hans, usually posting code with the

Code:

 ...

works to format on the post. But it doesn’t work here. How is that done on this board?

You’re right, thanks. I had it in mind C3 all along. And of course, that is what I put into the formula and the code. The code was a quickie and it shows.

Tough to change an old person!

BTW, Hans, usually posting code with the

Code:

 ...

works to format on the post. But it doesn’t work here. How is that done on this board?

Select cell D5, and go to Format > Conditional Format

In the left side, choose in the drop down “Formula is” and then in the box, put this:

=$C$3=”Yes”

Then in the Format button, choose red and bold.

For the movement to cell C5, I think, it would require a Change_Event code.

This might work for you. Right click the tab name, and select View Code, then in upper left, select Worksheet,

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
	If Range("C3").Value = "Yes" Then
		Range("C5").Select
	End If

End Sub

Select cell D5, and go to Format > Conditional Format

In the left side, choose in the drop down “Formula is” and then in the box, put this:

=$C$3=”Yes”

Then in the Format button, choose red and bold.

For the movement to cell C5, I think, it would require a Change_Event code.

This might work for you. Right click the tab name, and select View Code, then in upper left, select Worksheet,

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
	If Range("C3").Value = "Yes" Then
		Range("C5").Select
	End If

End Sub

Also, if you select an entire table (CTRL + SHIFT + 8), plus one row below and one column to the right and then hit ALT + =, it will put totals for each row and each column in one stroke.

Also, if you select an entire table (CTRL + SHIFT + 8), plus one row below and one column to the right and then hit ALT + =, it will put totals for each row and each column in one stroke.

Select cell A2, then Window > Freeze Pane

If you want to see column A, then select B2

Select cell A2, then Window > Freeze Pane

If you want to see column A, then select B2

Excel’s built-in formulas tend to be faster, so might consider that.

Excel’s built-in formulas tend to be faster, so might consider that.

Do you have Calculation set to manual?

Do you have Calculation set to manual?

I have been using ASAP Utilities for two years – and I agree, it is a daily work horse for me. Great tool.

I have been using ASAP Utilities for two years – and I agree, it is a daily work horse for me. Great tool.