Conditional Formatting Formats All

**uckycool** · 10-02-2012, 11:16 PM

Hello..

I have little problem in Excel 2007, if anyone could help?

I want to make conditional formatting to columns: if the value is larger than "10", then it will filled red light with dark red text.
What I found is, not only the cells with value larger than "10" that are conditionally formatted, also the cells with only text that are formatted as well (pict. below).
Cond. Formatting Err.jpg

I want to give format only to the cells with the value but not to the cells with text by using the 'conditional formatting' function.
Could anyone help? x)

Thanks!

**FDibbins** · 10-02-2012, 11:36 PM

did you use "10" in your CF, or just 10? and next time, dont upload a pic, you may just get shown a pic of how your solution worked. please upload a sampel workbook

**uckycool** · 10-03-2012, 12:12 AM

I have tried to use both 10 and "10" and the result is still the same.
And how to upload the sample workbook in the post?
*newbie alert
x)

**grizzly6969** · 10-03-2012, 12:39 AM

click GO ADVANCED then click on the paper clip and upload your file

**uckycool** · 10-03-2012, 12:56 AM

Okay got it. This is my workbook: Monitoring start Jan2012.xlsx
There you can see how my problem is.

**FDibbins** · 10-03-2012, 12:56 AM

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**FDibbins** · 10-03-2012, 01:16 AM

i removed all your CF and started again, and i used only the range you have, not entire columns (=$C$7:$G$372). you can change it back to $C$:$G$ if you want

then i used "use formula" for the CF and used this formula
=AND(ISNUMBER(C7),C7>1)

also, if you want to have more flexibility, chage the >1 to a cell reference that you can change as needed

i THINK what was causing your was the way you had absoluted your column range, but i changed that and cant remember what was there before

let me know if this is what you wanted?