Google sheets incorrect formula for conditional forrmating

Question

I'm getting the incorrect formula for this condition.

=AND(ISBLANK($C6), NOT(ISBLANK($I6)))

What I want to achieve - I want to check if the current cell, for example, C6 is not empty and if the corresponding I cell (with the same number) has value - if both are true apply formatting.

Answer 1

If you're trying to check whether C6 and I6 are not empty:

=AND(NOT(ISBLANK($C6));NOT(ISBLANK($I6)))

You haven't provided much information in your post. An example of the data and explaining why your original formula isn't working would help.

Edit for new information provided in comment

OP's Google Sheets locale is set to Polish which uses a semicolon (;) for separating arguments. This is the same for most of Europe. In other countries, a comma (,) is used instead. Here is an explanation of these differences: https://www.benlcollins.com/spreadsheets/sheets-location/

Putting the above formula as conditional formatting works when setting the file's locale to Polish. Only cells C6:C8 and C13:C14 are highlighted as they are the only ones with values in both columns.