Exel: Change cell background color based cell value?
- by David.Chu.ca
I have a column with function values of True or False:
=IF(ISNA(A1), false, true)
from row 1 to 5000+ rows. I would like to mark all the False as red background color or text as red. Is there any function available?