Seven does not seem to be undo-able
Select your range - Home Ribbon- Conditional formatting - New rule - Use a formula - Enter =$A1="red" and format as needed
Do the same for the others always using $A1 ( if col A of course, otherwise, adapt as needed)
You could probably find more explanation on YouTube or similar sites
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|