New to Excel .. Formula for a time related issue

[Russski]

1) I am trying to check the differences in 2 times in 2 different boxes for example the time in d5 is 23:30 and in c4 is 17:00 the previous day i need to right a sum that without the answer being visible does something like turns the square red if there is an error. I need to ensure that there is atleast 11 hours between and 2 times it can be the same day or a different day i would word it similar to this:-
Check that difference between D5 and E4 is equal to or more than 11 hours if it is not then tun d5 red a visual warning that There is a problem.
That is the first thing....
2) i want o count and show by turning a square blue that if the difference between d5 and d6 is greater or equal to 10 hrs if so turn d6 blue and if possible ad 1 to a counter counter can be in z1 for example.


********* I HAVE ATTACHED A REAL LAYOUT EXAMPLE AS WELL **********


If anyone can help with either or both i would be greatful..
I have heard you have to out this action somewhere else in excel so a bit of an idiots guide would be good thanks again
posted in programming as well thank you

[Russski]

I assume this is harder than I thought?

[Russski]

i'll boost it again heres hoping

[Russski]

last try boost final time

[AliGW]

Sorry, but your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Toonies]

Its not as you say "Harder than you thought"

its a help forum "that's not on Tap"

Patience is a Virtue

try

Conditional Formatting D5

Please Login or Register  to view this content.

try

[Russski]

thank you that works to a degree but I tried : =HOUR(E4-D5+1)<11 this also works but it doesn't work when both are empty as i want the square to go red but not when it goes red when both are empty and if e4 is empty an d5 isnt it doesnt work either thank you with your help so far.
in short exacty right except if E4 is empty do nothing

[Toonies]

add another layer of conditional formatting to the same cell

Please Login or Register  to view this content.

CF Fill Colour = No Colour

This CF code must be on Above the Red CF