It's only 9:40 a.m. here, so I have a little time. And if this part isn't
perfected, it'll be alright, I'll just have to manually check every 'Taken'
amount to make sure it doesn't exceed the 'Available' amount, like I have
time for that! ha ha

I can make this formula work in "test" areas of the spreadsheet which do not
contain condition 1. I think condition 1 is interfering with condition 2. My
condition 1 for alternate 3 row shading is: =MOD(ROW()-2,3*2)<3. I just don't
know exactly what the interference is and how to stop it.

"Pete_UK" wrote:

I hope you are on a different time zone than me - it's just after 3
here!

Highlight the cells D2 to D_whatever, with D2 as the "activecell", then
Format | Conditional Format then select Formula Is rather than Cell
Contents and enter this formula:

D2C2

then click the Format button and choose the effect/font/colour that you
wish and OK.

"_whatever" is the bottom cell that you use in column D (depends how
many employees you have). Then you can copy and paste this range of
cells to G2 downwards, then J2 downwards etc for each month of the
year. You could also use the Format Painter for this last part.

Hope this helps.

Pete