Same color scale looks different in multiple worksheets

[excelactuary]

I have a row containing numbers from 1 to 4 and I want to use a color scale to differentiate between the cells easier. The problem is, that I have multiple sheets and in some sheets, I get a different color scale, even though I use the same command and color scale.

I've already removed the "conditional formatting" on all worksheets, but the problem isn't resolved. Is there another way to clear the formatting of a cell, besides going to the "Conditional Formatting" tab and clicking "delete rule for entire sheet"?

Regards,
excelactuary

 

[Andrew Poulsom]

You can delete the rule for the current selection.

 

[CodeNinja]

I would use a quick macro to remove all pattern, tint and shade, and colors from all cells...

If you are not familiar with the vba editor do the following... if you are... ignore and just add the code
To do this, hold Alt & press F11 key to show the vba editor
Right click on the workbook you want to accomplish this in and insert a module.
Click on the module and enter the following code.

Sub test()
Dim sht As Worksheet
For Each sht In ThisWorkbook.Sheets
    With sht.Cells.Interior
        .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    With sht.Cells.Font
        .TintAndShade = 0
        .ColorIndex = 0
    End With
Next sht

End Sub

 

[excelactuary]

I would use a quick macro to remove all pattern, tint and shade, and colors from all cells...

If you are not familiar with the vba editor do the following... if you are... ignore and just add the code
To do this, hold Alt & press F11 key to show the vba editor
Right click on the workbook you want to accomplish this in and insert a module.
Click on the module and enter the following code.

Sub test()
Dim sht As Worksheet
For Each sht In ThisWorkbook.Sheets
    With sht.Cells.Interior
        .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    With sht.Cells.Font
        .TintAndShade = 0
        .ColorIndex = 0
    End With
Next sht

End Sub

I'm getting a Runtime error '13': Type mismatch

 

[excelactuary]

You can delete the rule for the current selection.

Doesn't work.

 

[Andrew Poulsom]

What do you mean by 'doesn't work'?

 

[CodeNinja]

I'm getting a Runtime error '13': Type mismatch

I ran this code twice and do not get a runtime error... where are you getting the error?

 

[Andrew Poulsom]

I ran this code twice and do not get a runtime error... where are you getting the error?

Maybe there's a Chart sheet in the workbook.