Spreadsheet Help

a few clarifying questions

row 17 - why yellow as before 3 months

3) Column J, calculate 1 year from Column H (I have used the EDATE,*12 however not sure how to get around the new starter '#VALUE', Ideally I would like this to state 'REQUIRED')

=IF(ISNUMBER(H2),DATE(YEAR(H2)+1,MONTH(H2),DAY(H2)),"required")

4) Column J, Highlight Amber if due date is 3 months (I tried =$J2>TODAY()-90 but this didn't seem to work properly?)

what did you want as a result - that should work and include future dtes

5) Column J, Highlight Red if due date has past (I think the Con formatting would be =$J2<TODAY() but just wanted to check)

yes - but will highlight blank cells
so maybe
=AND($J2<>"",$J2<TODAY())

what colour if =

you may need a stop if true and order the cells

as J2 >today()-90
will also highlight
J2<today()

if you select a range - say j1 to j24
then you need the formula to satrt at row 1

so
$J1 < today()

you also had $J$2 - so fixed at J2 for all calcs

j2>today()-90
and j2 <today()
overlaps and conflicts - what is it you want here

so all possible - just need some clarification and perhaps add some example expected results