Hi,

Desperate for help!

Ok so a few questions,

1) I have a cell that I want to highlight (B6) if (merged cell M/N6) = the value 100%. So I want it only to highlight B6 if the tasks are complete (100%) in MN6 if that makes sense.

2) I have a table, with the rows filled with Date:, Time:, Location: etc, I want these to remain RED, until the adjacent rows next to them contain values (varying values). So if the box to the right of Date contains any text/numbers I wasn't the DATE cell to turn blue (i.e. completed). This is a formaula I want to be able to copy to varying cells as at the moment they are red to indicate they are not completed however I want them to turn blue when completed (or in some cases, the value YES is typed in)

Hope this all makes sense, Im completely confused

Any help would be amazing thankyou