Conditional Formatting in Excel 2007
Posted on 2012-04-06
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.
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.