hallpett
asked on
Change background color on cells with green background color
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just to add: if you can't see the Format... buttons in the dialog initially, click the Options button.
ASKER
Thanks!
Considered myself to be an experienced excel user, but I can see there is still things to learn :-)
Considered myself to be an experienced excel user, but I can see there is still things to learn :-)
jppinto
Capture.JPG