Forum Discussion
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? Thanks!
the second one, =AND(A1=0,B1<>"") is working for me, with the format as Time
5 Replies
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
