You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi there,
Is there away to make the number that appears in Cell D159: "12200" (pls see red lines on image) have the same Tan colour so that it is easy to find when that same number "12200" appears in Column F? Basically have the blue F column produce a single cell with the Tan colour to show you exactly where the Strike value of "12200" appears amongst the numbers in Column F?
Cheers!
MacBook Pro 15″, macOS 13.4
Sure. Select all the cells in column F where you want the rule to apply. Start making a conditional highlighting rule for "Number, equal to". In the box where you you would type the number, click on the green oval instead. Click on cell D159. Change it to $D$159. Select the tan format you want. Click Done. My example below uses D2, but same idea.
Sure. Select all the cells in column F where you want the rule to apply. Start making a conditional highlighting rule for "Number, equal to". In the box where you you would type the number, click on the green oval instead. Click on cell D159. Change it to $D$159. Select the tan format you want. Click Done. My example below uses D2, but same idea.
Thanks for the Solution 👌.
Conditional Highlight so One Cell Matches the same Colour as Another Cell
