Hello everyone,
I'm using excel 2010, and I'm having some problem with conditional formatting. I need to highlight lowest price in each row, which I accomplished with formula =F6=MIN($F6:$J6) in formatting rule, and after that copied that rule with format painter to entire selection. But I have some empty rows, and I would like that they stay without any format. Formula =IF($F6:$J6="", "", MIN($F6:$J6)) doesn't work.
Can someone help me with formula, I would like to do it automatically, without selecting each empty row and deleting format for specific selection.
Thanks.
Bookmarks