Hello,
I'm trying to set up a spread sheet with multiple sheets all linking back to a summary sheet and its nearly complete I just need help and to see if its possible for this function to work.
I have set up a cell using the formula '=IF(Summary!E2>C4+30,1,0)' which changes the next cell along to a 1 or 0 depending if 30 days have passed since the invoice date, this works perfectly. if the cell is populate with a 1 I know to move it over so its due to be paid and I will process it, once processed I will move the figure on the sheet from unpaid to paid. I have set up conditional formatting so that when the cell is populated with a 1 it shows as red so it stand out that it needs to be paid. I now want that cell to change from a 1 to 0.5 as soon as I move the figure into the paid box and I can set the conditional formatting to show green if the cell is equal to 0.5. I have tried the formula '=IF(Summary!E2>C4+30,1,0)*((IF($G4>1,0.5,0)))' but unfortunately it wont work.
Any ideas?
Many thanks.
I'm trying to set up a spread sheet with multiple sheets all linking back to a summary sheet and its nearly complete I just need help and to see if its possible for this function to work.
I have set up a cell using the formula '=IF(Summary!E2>C4+30,1,0)' which changes the next cell along to a 1 or 0 depending if 30 days have passed since the invoice date, this works perfectly. if the cell is populate with a 1 I know to move it over so its due to be paid and I will process it, once processed I will move the figure on the sheet from unpaid to paid. I have set up conditional formatting so that when the cell is populated with a 1 it shows as red so it stand out that it needs to be paid. I now want that cell to change from a 1 to 0.5 as soon as I move the figure into the paid box and I can set the conditional formatting to show green if the cell is equal to 0.5. I have tried the formula '=IF(Summary!E2>C4+30,1,0)*((IF($G4>1,0.5,0)))' but unfortunately it wont work.
Any ideas?
Many thanks.