27665093.xlsx

<div>
Cool Beans! &nbsp;Works like a charm!<br />
<br />
Thank you!<br />
<br />
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 -- &nbsp;so enjoy!<br />
<br />
Ray
</div>


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

<div>
<div class="content wysiwyg-content">
Good day!<br />
<br />
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'. &nbsp;But I don't want the rows to format if the target row is blank.<br />
<br />
ie<br />
<br />
Dialog Formula is &nbsp; G1&lt;F1 &nbsp;with turning row A1:K1 Yellow. &nbsp;But I can'tfigure out how to prevent the formatting if G1 is blank!<br />
<br />
I have tried to use an &nbsp; &nbsp;if(F1=&quot;&quot;,&quot;&quot;,G1&lt;F1) in the dialog formula box, but it doesn't work.<br />
<br />
Any help appreciated.<br />
<br />
Ray
</div>
</div>


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

Conditional Formatting in Excel 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.