SOLVED

need help with a formula

Copper Contributor

I have a list of numerical inputs.

The input number range from 1 to 8

I need to format the output to change the color of the number if it apperas in the input.

How can this be achieved, with a formula or conditional formatting for a list of inputs that's extremely large. I don't have the time to select and format if it appears.

2 Replies
best response confirmed by null null (Copper Contributor)
Solution

You may apply the rule like this

image.png

Please see attached

Thanks very much, This worked
1 best response

Accepted Solutions
best response confirmed by null null (Copper Contributor)
Solution

You may apply the rule like this

image.png

Please see attached

View solution in original post