• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • Last Modified:

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?
0
morinia
Asked:
morinia
1 Solution
 
dlmilleCommented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now