conditional formatting to highlight number of cells based on count

Ravindu94 See attached. Cells with blue text require input. All others calculate automatically. Note that I use real dates in the column headers, aligned to center across two cells (i.e. NOT merged). Start date includes a time element as well to help calculate the end date and time in F. The example only covers 4 days.

Rather than applying multiple conditional formatting formulae, I chose to test the condition in columns G:N, resulting in TRUE or FALSE (formatted white text on white background), thus invisible and then apply conditional formatting on the entire row area with one simple rule (TRUE = Green text and background).

Perhaps feasible in your situation. If so,I trust you can apply this method to your own schedule yourself.