Forum Discussion
Conditional Formatting Formulas
Hi
If you're able to attach a sample file I can take a look.
Most common mistake I find when users have formulas in conditional formatting is the $ signs get mixed up, or the wrong cells are highlighted when writing the formula.
e.g. highlight all cells that you want the conditional formatting to apply to before writing the conditional format formula and make sure that formula is relevant to the top left corner cell that is highlighted.
Then after applying the formatting click on a different cell and check the formula that is being applied to it via Conditional Formatting > Manage rules. If the formula isn't referring to the correct cell then start over and change your $ signs.
Having said all this - it could be a totally different reason :)
I'm trying to use the formulas that you did in relation to my data, but nothing changes color. I'm not sure what I should do differently.
Update: I can get some of the names to change color correctly, but not all of them become colored and I'm not sure why.
Hi
If you're able to attach a sample file I can take a look.
Most common mistake I find when users have formulas in conditional formatting is the $ signs get mixed up, or the wrong cells are highlighted when writing the formula.
e.g. highlight all cells that you want the conditional formatting to apply to before writing the conditional format formula and make sure that formula is relevant to the top left corner cell that is highlighted.
Then after applying the formatting click on a different cell and check the formula that is being applied to it via Conditional Formatting > Manage rules. If the formula isn't referring to the correct cell then start over and change your $ signs.
Having said all this - it could be a totally different reason :)
So I figured out that I had spaces next to some of the names in the table and not in the same ones in the column. Thank you!