Change background color on cells with green background color

Posted on 2011-05-12
Last Modified: 2012-05-11
Have a big sheet where many cells (spread around) have green background color. Is there a easy way to change background color only for this cells from green to red?
The green cells don't have anything in common except beeing green so I can't use conditional formating. Don't know if there is a fast and easy solution, but appreciate any tips or hint.
Question by:hallpett
    LVL 85

    Accepted Solution

    Have you tried the Find and Replace dialog using the Format buttons?
    Note: if the colours had been applied using a Style, it would be very simple as all you would have to do is alter the style and all the cells would adjust. Might be worth doing this now, if you think the colours may need to change again.
    LVL 33

    Expert Comment

    What rorya was saying is to use the Find and Replace (Ctrl+H) and find the green fill color and replace by the red fill color. Please take a look at the attached image.

    LVL 85

    Expert Comment

    by:Rory Archibald
    Just to add: if you can't see the Format... buttons in the dialog initially, click the Options button.

    Author Comment

    Considered myself to be an experienced excel user, but I can see there is still things to learn :-)

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now