Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

Conditional Formatting in Excel 2007

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
RayLBailey
Asked:
RayLBailey
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
RayLBaileyAuthor Commented:
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
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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