Solved

Conditional Formatting

Posted on 2012-03-23
1
272 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 41

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

785 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