Forum Discussion
Arthianne
Nov 06, 2020Copper Contributor
New to excel and trying to figure out how to combine cell outputs to determine different row colors
I'm making a spreadsheet for excel and am extremely new to it, I'm making a sheet with a series of drop down menus and want the colors of the rows to change with the series of answers, YES, NO, REPLACED, REPLACE. I want to be able to change the row color based on the combination of answers provided.
If xx is yes and xx is yes and xx is no become xx color
if xx is no and xx is yes and xx is yes become xx color
etc, etc until all combinations are accounted for,
I've gotten the very very basic rules done like this
And now im just trying to figure this out, any help is greatly appreciated, if you need more info, please ask
6 Replies
- BennadeauIron Contributor