Hi all.
Is there any way that using conditional format, a cell (K7) can have a colour fill applied if two other cells (L7 & M7) have any content in them? It would be a time stamp in each of L7 and M7 (doesn’t matter what the time stamp is). I would like the conditional format rule to run on K7 only when both of these cells (L7 & M7) have a time stamp in them.
As always appreciate everyone’s help.
Trevor.
Is there any way that using conditional format, a cell (K7) can have a colour fill applied if two other cells (L7 & M7) have any content in them? It would be a time stamp in each of L7 and M7 (doesn’t matter what the time stamp is). I would like the conditional format rule to run on K7 only when both of these cells (L7 & M7) have a time stamp in them.
As always appreciate everyone’s help.
Trevor.