Conditional Formatting

I am trying to use conditional formatting to test the value of column F equal to blanks or null. IF condition true I would like to highlight the entire row in "Yellow Fill".

What is the syntax for the conditional statement?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
You can use:

=SUBSTITUTE($F1," ","")=""

which replaces the blank spaces with nullstring, if any exist and compares the result to nullstring.

See attached demonstration

Dave
showBlanks-r1.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.