LinkBack URL
About LinkBacks
Tried this and I could not get it to format. Trying to format the cell not based on it's value but the formula, so not sure which of the options on the drop downs I should be using.
Tried this and I could not get it to format. Trying to format the cell not based on it's value but the formula, so not sure which of the options on the drop downs I should be using.
Works for me.
Here's a small sample file that demonstrates this.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you for your patience. I do not understand the syntax of the formula, would you put it in layman's terms? I have attached a portion of the file that I am building so that you can have a better idea. The columns that I am working with are greyed out.
Harrytheb2.xlsxExample1.xlsx
I didn't download your files.
After reading the top post again I think I have misunderstood what you want to do.
So, it's based on the stop time from the row above and the start time from the row below? Is that correct?Originally Posted by Harrytheb
Hi Tony, I have changed the post a couple of times for clarity. You are correct, it is the stop time from the row above and the start time from the next row.
Based on the Harrytheb2.xlsx file...
Select the range B11:B19 starting from B11.
Conditional formatting
Formula:
=AND(COUNT(H10,B11)=2,MOD(B11-H10,1)<TIME(8,0,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks