Henry
02-01-2011, 02:14 PM
Hi
I've run into a problem that I haven't been able to find a solution for yet and was hoping someone could help me with it. I have worksheet with 12 columns with the data arranged in rows. For each row, there may be 2 to 12 entries. I'm trying to use conditional formatting to fill the cells of the highest (green) and lowest (red) values, but only for those cells that contain data. Data is numeric only.
Right now, it works once I enter the values, but blank rows are all filled with green and values of 0 result in that cell and every other blank cell in the row to be filled with red.
I am using the cell value equal to =MAX($A11:$L11) for the highest value and =MIN($A11:$L11) for the lowest, in that order.
Do I need to resort to VBA for this ?
Thanks in advance !
I've run into a problem that I haven't been able to find a solution for yet and was hoping someone could help me with it. I have worksheet with 12 columns with the data arranged in rows. For each row, there may be 2 to 12 entries. I'm trying to use conditional formatting to fill the cells of the highest (green) and lowest (red) values, but only for those cells that contain data. Data is numeric only.
Right now, it works once I enter the values, but blank rows are all filled with green and values of 0 result in that cell and every other blank cell in the row to be filled with red.
I am using the cell value equal to =MAX($A11:$L11) for the highest value and =MIN($A11:$L11) for the lowest, in that order.
Do I need to resort to VBA for this ?
Thanks in advance !