Customised colour scale using / as the value

[winds]

How to make a color scale in excel so that it applies to "/", and the color scale already starts red when only this value is inputted without the need to input other values.

In context, from what I understand, conditional formatting works so that as more values are inputted, the color scales adjust, but in this case that I am looking for, the color scales don't need to adjust, so when "/" is inputted it starts off with say red immediately and not the usual case say green so that when another "/" is inputted it will adjust.

 

[etaf]

i think this will need VBA Solution , which i do not provide

you could perhaps setup a range of rules
maybe 8 rules
so you change colour each 100

so RED = =AND(A2="/",COUNTIF(A2, "/")<=100)

then the shades in between maybe something like

lighter red <=200
Light orange <=300
orange <=400
Light Yellow <=500
Yellow <=600
light green <=700

Green = =AND(A2="/",COUNTIF(A2:$A$2,"/")>700)

Also not sure how many shades of colour are available - 300 shades of 1 colour seems a lot , even if possible in Excel - I guess VBA using RGB colour code , but not sure I think using colour index has 56 colours in total

BUT i could easily be wrong on this - as i have never really used anything like that many colours for conditional formatting

 

[winds]

Hey there, eventually I just did a workaround where I copypaste the complete colour scale into word, paste that back into excel, remove the values then replace it with /.
Thank you for your help.

 

[etaf]

Thanks for providing the update
Glad you have found a solution/workaround

You could on another row count the number of / quite easily
1,2,3,4 etc
But I’m still not sure how a colour scale would work

How did you create it in word?

 

[winds]

Just copy a complete colour scale from excel into word, then copy from word back to excel, and remove values so only the colours are left.