Steps to troubleshoot Conditional Formatting issue in Excel:- Select the correct range of cells to apply Conditional Formatting.
- Ensure that you are on the correct worksheet.
- Verify that the cells you want to format are not locked.
- Check if a filter is applied to your data and clear it if necessary.
- Close and reopen your workbook to fix any stuck issues.
If you are still having trouble, please let me know and I'll be happy to assist you further. Additionally, if you can provide more details about your issue, such as the version of Excel you are using or the specific type of Conditional Formatting you are trying to apply, it may help me provide more targeted assistance.
Formula:
//Sample macro code
Sub ApplyCF()
Range("A1:A10").Select
Selection.FormatConditions.AddColorScale ColorScaleType:=3
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
Selection.FormatConditions(1).ColorScaleCriteria(1).Type = _
xlConditionValueLowestValue
Selection.FormatConditions(1).ColorScaleCriteria(1).FormatColor.Color = _
7039480
Selection.FormatConditions(1).ColorScaleCriteria(2).Type = _
xlConditionValuePercentile
Selection.FormatConditions(1).ColorScaleCriteria(2).Value = 50
Selection.FormatConditions(1).ColorScaleCriteria(2).FormatColor.Color = _
8711167
Selection.FormatConditions(1).ColorScaleCriteria(3).Type = _
xlConditionValueHighestValue
Selection.FormatConditions(1).ColorScaleCriteria(3).FormatColor.Color = _
8109667
End Sub