Forum

Notifications
Clear all

Conditional Formating with Formula

3 Posts
2 Users
0 Reactions
73 Views
 Madi
(@madisal66)
Posts: 61
Trusted Member
Topic starter
 

Hi every one

i have attached, any body give idea formula with conditional formatting for start time and end time

 

Happy Christmas

conditional-format-with-formula.jpg

 
Posted : 27/12/2017 9:02 am
(@fravis)
Posts: 337
Reputable Member
 

Hi Mohamed,

I made the time ranges in this example sheet a little different from your jpg, but you can do whatever you want of course if you understand the formula. I made it with a simple 'AND' (starttime bigger than the time above and lower than the time endtime). Think you can manage it yourself from here.

 
Posted : 27/12/2017 12:11 pm
 Madi
(@madisal66)
Posts: 61
Trusted Member
Topic starter
 

Hi Frans, and thanks for formula

 
Posted : 28/12/2017 1:30 am
Share: