Checking for just spaces
In conditionally formating I want to check if the cell has just spaces
I used the following logic
if the length of the cell is greater than zero (multiply) if the length of
the trimmed cell = 0. if both of these conditions are true - turn the cell
red - otherwise leave alone. This works - however is there an easier way to
do this?
|