Solved

Conditional Formatting

Posted on 2012-03-23
1
273 Views
Last Modified: 2012-03-24
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
Comment
Question by:morinia
1 Comment
 
LVL 42

Accepted Solution

by:
dlmille earned 250 total points
ID: 37760044
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question