Conditional formatting with using formula: 'Applies to' is not working properly

[OzgunOzden]

Hello,

Could someone help me for the problem that I'm facing with the conditional formatting?

As you can see in the following image conditional formatting rule sould have been applied to A2:D2 and A3:D3 range. But only the cells of the A column is getting formatted with this rule.

What should I do to apply the format to all of the cells (TRUE values ofcourse) between A and D columns?

Thank you in advance!

[#2 · Accepted solution]

@OzgunOzden 

=IF($C2="F",TRUE,FALSE)

=IF($C2="M",TRUE,FALSE)

Add the dollar sign before C2. This works in my spreadsheet.

[#3]

@OliverScheurich

It worked. Thank you very much.

[#4]

@OzgunOzden 

In addition, it's not necessary to overcomplicate formula with IF(). Just

=$C2="M"

is enough.

[#5]

@Sergei Baklan

Very useful information. Thank you!