Conditional formatting only selected cell or column

[graemeal]

Hi,

This problem seems to pop up often. When I change the conditional format of one cell it changes all formats in the adjacent 2 columns.

How do I CF the selected cell only. Do I have to delete the CF and start again each time.

Thanks

Windows 7 Excel 2007

 

[Tom Urtis]

That has not happened to me, but Excel can be quirky. By any chance, are there any merged cells in the neighborhood.

 

[graemeal]

No merged cells. Yes a strange one but as I was sending my first post I discovered a fix. Delete and start again. Not the ideal fix but then all OK.

Thank you kindly

 

[CWatts]

I've found it helpful to change the drop down box when in the window to manage conditional formatting rules. it defaults to current selection, but changing that to "This Worksheet" helps show any that may have crept out so you can delete those rules and then you can make sure your "Applies to..." column is set up right.

Good luck; conditional formatting can get cumbersome especially when managing a lot of rules in a window you can't expand.

 

[graemeal]

Thank you kindly