Need help with Cnditional Formatting. One column works fine, the others wont accept format

[chris.sweezy]

I have Column G formatted to change Font color based # of days proximate to date entered in Cell of each column. I cant get column E or C to accept same formatting. Everything is same....????? So frustrating!

[dingdongsilver]

I checked that out. Go to conditional formatting and manage rules. Select 'this worksheet' in the 'show formatting rules for:' drop down. Delete everything that doesn't show a $G$6 in the left column. Now copy the G column from G4 to G28. Paste that in the E column. Now go back to the rules manager and change the formula from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Long way round but it's methodical and easy to do.

[chris.sweezy]

You said to "Delete everything that doesn't show a $G$6 in the left column"... none of the formulas show a $G$6 in left column. So I delete all of them?? there is no formatting to copy.. ??? just like starting over....??

[dingdongsilver]

Delete the things like what's in the red box. Basically I'm just saying remove all of the conditional formatting from every column EXCEPT the G column. Then copy the G column and paste it into another column. That will copy the conditional formatting too. Then just go and adjust the formula in the rules manager.

this.png

Also I attached whole file fixed up if you need it immediately.