Colour in spreadsheets that are formulated
Closed
Hello,
I would like to know how to do the following on excel
Same sheet with the amount of calls taken in number form goes into a cell then the formualted box that has a percentage formulae in it has a colour in it therefore if the box needs 3 to make it completely green bu only having 2 in the box would only have a partial amount green showing in the box
Kind regards
Trevor
I would like to know how to do the following on excel
Same sheet with the amount of calls taken in number form goes into a cell then the formualted box that has a percentage formulae in it has a colour in it therefore if the box needs 3 to make it completely green bu only having 2 in the box would only have a partial amount green showing in the box
Kind regards
Trevor
Related:
- Colour in spreadsheets that are formulated
- Crimping colour code - Guide
- How to change notification colour in whatsapp - Guide
- How to use spreadsheets - Guide
- Sound card colour code - Guide
- Compare excel spreadsheets - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 20, 2016 at 01:16 PM
Jul 20, 2016 at 01:16 PM
Bridge, Good afternoon.
Using the formula of the previous example: $F$5 = "YES", this should not happen.
Have you checked if there is only this conditional formatting rule in this cell?
Try using this conditional formatting in another cell and verify if the same thing happens.
Using the formula of the previous example: $F$5 = "YES", this should not happen.
Have you checked if there is only this conditional formatting rule in this cell?
Try using this conditional formatting in another cell and verify if the same thing happens.
Jul 20, 2016 at 11:35 AM
It is working when the text Yes is present but if the cell then contains the word No it is remaining red.
Am i missing something in my formula?