CODEWITHSUNDEEP
excelexcel-formulaformula
majesticoj
majesticoj

Reputation: 101

Simple Conditional Formatting Rule Not Working in Excel

I found other Excel conditional formatting questions on the board but couldn't find a solution for mine.

The rule is simple: if cell B10 equals "y", then format (I'm formatting B12)...

B10="y" This is what I enter into the rule field before closing the box... The cell (B12) still won't format...

Additionally, when I re-open the conditional formatting window, I find that extra quotes have been added... Aside from that, what am I doing wrong?

enter image description here

Upvotes: 0

Views: 267

Answers (1)

toroc
toroc

Reputation: 126

There is additional quotation mark:

I marked it on a screen dump

Consider formatting based on cell content instead of using formula: see on a picture :)

Upvotes: 1

Related Questions