@Shrey10
To make both cell C8 and D8 turn red when the time goes over 36 minutes, you can use conditional formatting in Microsoft Excel.
Here is how you can set it up:
- Select cells C8 and D8 simultaneously by clicking and dragging to highlight both cells.
- Go to the "Home" tab in the Excel ribbon.
- In the "Styles" group, click on "Conditional Formatting."
- Choose "New Rule" from the dropdown menu.
- In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format."
- In the "Format values where this formula is true" field, enter the following formula to check if the time exceeds 36 minutes:
=AND(C8<>"", OR(C8-TIME(0,36,0) > 0, D8-TIME(0,36,0) > 0))
This formula checks if either cell C8 or D8 contains a time value and if the time is greater than 36 minutes.
7. Click on the "Format" button to specify the formatting options for cells that meet the condition.
8. In the "Format Cells" dialog box, go to the "Font" tab, and select the red font color.
9. Click "OK" to confirm the font color.
10. Click "OK" again in the "New Formatting Rule" dialog box to apply the conditional formatting.
Now, whenever the time in either cell C8 or D8 goes over 36 minutes, both cells will turn red.
Remember that this approach assumes that cells C8 and D8 contain valid time values. If you are working with time values in a specific format (e.g., hh:mm AM/PM), make sure the cell values are recognized as times. You can format the cells as time values using the cell formatting options if needed. The text and the steps are the result of various AI's put together.
My answers are voluntary and without guarantee!
Hope this will help you.
