Hi,

I'm using Excel 2010.

I am having a difficulty with conditional formatting.

If I choose Conditional Formatting>New Rule from the Home Ribbon, the group select icons are inactive and do not permit me to set lowest value or highest value. Rule type is set to 'format all cells based on their type'.

It happens in any spreadsheet including a new one.

Anybody able to tell me what I'm doing wrong?

Thank you

BwestOZ