assuming your input cell is C3, use Formula is... option and enter formula as
=LEN($A3)*LEN($C3)
set formatting options and away you go!
NB this checks for any entry, if you specifically only want to find TEXT use ISTEXT()
Discussion on:
Message 21 of 23
0
Votes
RE: Changing cell color based on text in two cells
Posted by jbenton@...
13th Feb
