So, you haven't attempted to do anything in this assessment?
Posts by GlennUK


Select from cell A2 down to the end of your data (all columns of data), and do Conditional Formatting/Formula/ with a formula of =$A2=TODAY() and choose the fill colour you want.


Have a look at this ... using a Formula in Condition Formatting with AND function ... by the way, your Yes entries are actually going to be "Yes " which may have confused others who looked at this:
Report test v2.xlsx 
If a cell has a formula, it is NOT blank. Even if the result is a null string ... being "" in other words.

I would guess that the cells are not blank, even though they look blank. If you attached the workbook with the formula, people would be able to debug for you.

=address(B1,4)
B1 has the formula =Today() to give todays date
So, cell A1 has the result $D$45136 ? And, if that is the case, you want to go to row 45146? Your requirement does not make sense. If you have a date in B1, and you want to go to the row for that date, I would have thought (in A1) a formula of =HYPERLINK("#A"&IFNA(MATCH(B1,A2:A9999,0)+1,1),"goto row "&IFNA(MATCH(B1,A2:A9999,0)+1,1)) would do it (assuming I guessed what is required correctly).

Maybe if you show your formulas, and explain the logic used, people will be able to advise?



Just do ribbon command Data/Edit Links, and change source from being the August file to being the September file. All formulas change automatically.




Use this formula in F2: =IF(B2<today,0,C2+(ROUNDDOWN((SUM(C$1:C1)SUM(D$1:D1,F$1:F1))/COUNTA(B3:B$31),0)))

Explain the logic of what the process should be when the Variance total is larger than the number of days left in the month.

Change formula in cell F2 to be: =IF(B2<today,0,C2+(SUM(D$1:D1,F$1:F1)<SUM(C$1:C1))) and copy down.

I hate any kind of date stamp formula where iteration and circular refs are required ... and your query sounds like that kind of thing. Can I ask why you are not solving this using VBA with Worksheet_Change event?

If you are copying to other columns, then your reference to column A cells should be preceded with a $, like:
=IF($A23="Month Ending",SUBTOTAL(9,K$2:K23) 
You can't do that in one step, no. I've done similar, using formulas to generate the link formula that would work, but as a text string, then converting that to formulas afterwards. Do you see what I mean?