Excel, look for complex formulas

[tmr064]

In a workbook used to track rental income, one column shows the expected income amount for a month. On rare occasions, i will indicate that an additional amount is due by adding the additional amount to the standard rent. On rare occasions, I forget to remove the additional amount in the next month. For example, an amount would usually be 1000 but if an additional $25 is due, I change the amount to =1000+25 . Is there a way to test for the "plus" sign in conditional formatting, or is there another way to address the issue?

Thanks

 

[bluedragon2]

Instead of add figures to your rent income, I would have a cell defined for additional charges then add that to the rent for a total.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[ETID]

Sub Find_Formulas()
Dim C As Range, WS As Worksheet
For Each WS In Worksheets
For Each C In WS.UsedRange.Cells
If Mid(C.Formula, 1, 1) = "=" Then
MsgBox ("Cell " + C.Address + " In the WorkSheet Named " + WS.Name + " Contains the Formula... " + C.Formula)
Else
End If
Next C
Next WS
End Sub

 

[GlennUK]

Yes, you can show which cells have formulae by conditional formatting. John Walkenbach covers it here ...

http://j-walk.com/ss/excel/usertips/tip045.htm

Cheers, Glenn.