Forum Discussion
Solved
Conditional formatting using data from 2 different cells
Hello, I am trying to conditionally format a cell to change fill color if it's own value equals "0:00" AND if another specific cell of my choosing has any value. What would be the best way to do this...
the second one, =AND(A1=0,B1<>"") is working for me, with the format as Time
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.