Thread: Highlight a cell with the wrong data without Conditional Formatting

Ok so I tried using conditional formatting to solve my problem but it says that i cant reference other worksheets or workbooks using conditional formatting.

I am making a time sheet up with a total number of hours in cell B38. I would like the cell to stay red as long as the data in cell B38 is <6:30, meaning 6 hours and 30 min. I want it to add cell B38 and cell C37 from another worksheet and stay filled red unless the
cell = 6:30.

the format for B38 is for text because I need for people to be able to enter times a particular way. Example: 6:30 is 6hrs and 30min not 6:30pm or am, :30 = 30min not 1230 am...

Let me know if this is too confusing and I will try to write it a different way. Thanks in advance.

Mike

Here is the formula that I have in cell B38:

=IF((0&B20)+(0&B24)+(0&B28)+(0&B32)+(0&B36)=0,"",TEXT((0&B20)+(0&B24)+(0&B28)+(0&B32)
+(0&B36),"h:mm"))

This is so people can enter times into their respective cells and have B38 show the sum as hrs and mins versus an actual time like 4:30pm or 2:00am and so on.

The same formula is on another worksheet in the same workbook. I want to be able to highlight cell B38 and the corresponding cell, C37, from the other worksheet if the sum of B38 and C37 < 6:30 and stay highlighted until the sum is = 6:30.