Solved

Conditional Formatting in Excel 2007

Posted on 2012-04-06
2
279 Views
Last Modified: 2012-08-13
Good day!

I am using a spreadsheet to track parts. I have successfully used the conditional formatting Dialog to highlight a row if the formula evaluates to a 'less than'.  But I don't want the rows to format if the target row is blank.

ie

Dialog Formula is   G1<F1  with turning row A1:K1 Yellow.  But I can'tfigure out how to prevent the formatting if G1 is blank!

I have tried to use an    if(F1="","",G1<F1) in the dialog formula box, but it doesn't work.

Any help appreciated.

Ray
0
Comment
Question by:RayLBailey
2 Comments
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
Comment Utility
Hello,

not quite sure I understand the setup, because there is some conflicting information

>> prevent the formatting if G1 is blank

>>  if(F1="","",G1<F1)

F1 or G1 ? Which one will be tested for blank?

In any case, see the attached file for an example. The conditional format applies to $A$1:$K$10 and the formula is

=AND(NOT(ISBLANK($F1)),$F1>$G1)

cheers, teylyn
27665093.xlsx
0
 

Author Closing Comment

by:RayLBailey
Comment Utility
Cool Beans!  Works like a charm!

Thank you!

I know this question isn't necessarily worth 500 points, but my Browser wwon'tlet me select a lower amount when I posted the question --  so enjoy!

Ray
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

763 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now