Forum Discussion
Equal sign to copy a cell's text and color
I volunteer for a non-profit that helps people needing housing, food, utilities, etc. Currently, they use a printed 3-page intake form that has to be filled in by hand by the client. If they don't ...
I assume, you just need conditional formatting rule for each cell. So, when any cell of that particular column of form is blank, means missing answer will be yellow highlighted. Otherwise the cell will be no fill, means white back fill. What about this simple rule in CF.
=$C3=""
or
=$C3=0And apply to your desired range. A small file is attached.