Conditional Formatting without First Row - Excel 2003.

[Book_Girl]

Help!

I have a spreadsheet which includes columns like:
January 2012
£30.00
£20.00
£48.99

and so on, for each month this year. What I need is for anything for £30 or over to be bold and in blue.

I have at the moment the following conditional formatting:
Cell Value is greater than or equal to 30 with the formatting blue and bold.

This works but it is also highlighting the January 2012 columns which I don't want. Is there a way of stopping this? I can't see a way out of this.

Thanks.

 

[Gerald Higgins]

There are probably several ways to handle this, but the easiest would be to simply select the cells where you don't want the conditional formating (CF) to appear, then open the CF dialog box, and delete the format(s) for those cells.

 

[T. Valko]

Help!

I have a spreadsheet which includes columns like:
January 2012
£30.00
£20.00
£48.99

and so on, for each month this year. What I need is for anything for £30 or over to be bold and in blue.

I have at the moment the following conditional formatting:
Cell Value is greater than or equal to 30 with the formatting blue and bold.

This works but it is also highlighting the January 2012 columns which I don't want. Is there a way of stopping this? I can't see a way out of this.

Thanks.

Don't apply the formatting to the column headers.

In Excel text (your column headers) evaluates to be greater than any number.

="text">1000000000 = TRUE

Since that condition evaluates to TRUE the format is applied.

 

[Book_Girl]

There are probably several ways to handle this, but the easiest would be to simply select the cells where you don't want the conditional formating (CF) to appear, then open the CF dialog box, and delete the format(s) for those cells.

Worked, thank you. I even knew that was a way of doing it....Monday brain has hit me hard this week