Related:
- Colour in spreadsheets that are formulated
- Crimping colour code - Guide
- How to change whatsapp notification colour - Guide
- How to use spreadsheets - Guide
- Compare excel spreadsheets - Guide
- Notepad colour - Guide
2 responses
You are referring to "CONDITIONAL FORMATTING". On your top ribbon, press the conditional formatting button and build the formula!
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?