Clearing specific status cells with nested if statement??

[shmalds]

Hi,

I Know this type of subject is well covered but I cant seem to find exactally what i need.

Looking for an If statement to clear specific status cells

steps would be

if any cells in column L = CANCEL

then clear contents of specific related O column cell.

Thanks in advance

[GMBing]

The L cell is the command comment cell and will contain the instruction issued to markket (L10 Fav)
The O cell is status and will prob be PLACED although many other comments can appear (O9 Fav)

Using page code under workshett calc
If L10 = "" and O19 - "PLACED" Then
O9 =""

will re arm trigger as markets auto change via Guardian auto switch

Be very careful using VBA to clear status cells. I once tried a time command when two time values where equal and managed to place 17 bet commands to live markket in 1 second


Regards

G