Forum Discussion

ChrisBlair's avatar
ChrisBlair
Copper Contributor
Jul 25, 2019
Solved

assigning a numerical value to a colored cell

Good Day All, I have a co-worker who has used 'fill color' to assign a relative risk. Green = Low, Yellow = Medium, Orange = High, and Red = Significant based on the impact to the overall requiremen...
excel
  • nabilmourad's avatar
    nabilmourad
    Jul 25, 2019

    ChrisBlair 

    I am happy I could help you Chris

    Please mark the answer as "Accepted " and Like .

    Thank you :) 
    Good Luck

    Nabil Mourad

GlennI1475's avatar
GlennI1475
Copper Contributor
Sep 14, 2022

nabilmourad 

 

I'm on a MacBook using MacOS Monterey 12.5.1.  Excel for Mac 16.65

 

I'm trying to count the number of cells in a row that I have assigned a color.  This tip doesn't work as the Find function (to the right of home - "find & select") doesn't provide any options when Options on the bottom right is selected.  I do get the "within", "search" and "look in" drop down boxes but selecting Options results in a "Find What" box. The drop down from that is a blank gray selection box. 

 

Please help!

mathetes's avatar
mathetes
Gold Contributor
Sep 14, 2022

GlennI1475 

 

For what it's worth, nabilmourad has not had a post or response on these boards for over two years.

 

Rather than picking up on a thread that itself is now ancient history, you would be better off starting an altogether new thread with your question, spelling it out a bit more fully in the process. For example, "this tip" that you refer to --- what is it?