Forum Discussion
Conditional formatting using data from 2 different cells
the second one, =AND(A1=0,B1<>"") is working for me, with the format as Time
It actually depends on how your data is formatted in the "0:00" column. If it's formatted as text then you would use =AND(A1="0:00",B1<>""), but if it's a number, you should be able to use =AND(A1=0,B1<>""). Keep in mind that A1 and B1 in this formula will need to be changed to the appropriate cells for your data.
It's actually formatted for "Time". I tried the suggested formula but it didn't work. Is there a different format need for a "Time" format?
the second one, =AND(A1=0,B1<>"") is working for me, with the format as Time
It worked! I had quotations around the 0 that was preventing it from working. Thank you for your help!
Great to hear. You're welcome, I'm glad I could help.