conditional formatting...

[shinsei jutsu]

Hi all, please could you help me with this problem I am trying to solve.

I have a spreadsheet with columns headed by date and the rows are payments in.from different people. What I am trying to do is that if a payment of 55 comes in on the 1st of the month the rest of the month gets shaded a different colour. If it is any other amount then it stays it's default colour.
As this sheet is for a whole year I was hoping I could do this in some way so that I could drag it trough the whole sheet. I can do it if I type it month by month I think.

I hope this makes sense.

Thank you in advance for any help you can give.

[arthurbr]

Hi and welcome to the board
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[shinsei jutsu]

Thank you, I didn't realise that was possible.

I've attached the spreadsheet I'm working on with some dummy data. Hopefully with the description above and this it may make a bit more sense.

Thanks again.

[shinsei jutsu]

Is this sort of thing not possible then? Anyone got any ideas?

[arthurbr]

Is the payment due the 1st of the month or the first tuesday of the month ?

[shinsei jutsu]

The first Tuesday. Sorry I should have made that clearer.

[arthurbr]

Sorry I'm a bit late. Does the attached meet your requirements?

[shinsei jutsu]

No need to appologise at all. This is great, although I notice it is only working for Jan and Feb, and I am not too sure what you have done to be able to sort the rest out. Could you explain your formula for me or help me correct the rest of the sheet please?

Thanks loads for the effort you have put in already.

[arthurbr]

As you saw, the CF doesn't extend dot other months as there was no data Just " paint" it on the rest of the range.
The formula evaluates when the 1 st Tuesday happens ( my formula could probably be trimmed) then looks at the value underneath the 1st Tuesday's date. If it is = 55 the CF is apllied, otherwise, not

[shinsei jutsu]

That is superb. I've just copied it across and it works fantastically. It also works if I insert a row (say by right clicking on row c and hitting insert). It doesn't work if I use the * section (cell A 13 I think) to add a row, but this is a minor thing which I can live without.

Thank you so much for your help.

[arthurbr]

I extended to the existing range in the attached

[shinsei jutsu]

Thank you for all your help, you have saved me an amazing amount of work. Is there a way I can change this thread to SOVLED?

[arthurbr]

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[shinsei jutsu]

thanks again for all your help.