I have a sheet of formulas. If someone types over a formula I want the font to turn red. So this is either a conditional format based on the first character in the formula being = (or some other indicator of whether it is a formula or not) or preferably a macro based on when a cell calue is changed.
I have tried using
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) with code to turn the cell red
But this turns the cell below red because the active cell is already in the cell below. It almost works if the code turns the cell above red but not if a filter is on because the active cell moves down to the next filtered cell and you end up turning a hidden cell red rather than the cell you changed.
Must be a simple solution that someone can direct me to.
Thank you
I have tried using
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) with code to turn the cell red
But this turns the cell below red because the active cell is already in the cell below. It almost works if the code turns the cell above red but not if a filter is on because the active cell moves down to the next filtered cell and you end up turning a hidden cell red rather than the cell you changed.
Must be a simple solution that someone can direct me to.
Thank you