Spreadsheet color one line from cell values

[Nicolas Goutte]

From Spreadsheet, how can I color one line from cell values
example: 
column B | column E  |
"status"    |  expected |
"one"       |  "two"       |

I tried with formula:  =AND($B1="status",$E1="EXPECTED")

But I have error message

"The formula cannot refer to its own cell, which will lead to inaccurate calculation results"

I am expecting that with "$" the formatting will be applied on the whole line, which is the case but with an error !

Thank you.

[Stiltsoft support]

Hi @Nicolas Goutte ,

Please define what app and what macro you are using, there are no any spreadsheet macros in Confluence out of the box.

Our company develops the Table Filter, Charts & Spreadsheets for Confluence app that provides the Table Spreadsheet macro with a similar interface.

So, in case if we are talking about our app, I suggest referring to our support portal. Please export your problem spreadsheet in the .tfss format and attach it to the ticket (the portal is confidential). Also if your tags are wrong and you are on Data Center, please specify the app's version.

Meanwhile, we couldn't reproduce the issue:

=AND($B1="status",$E1="EXPECTED")

Seems that we've got the expected result.

[Alexey Mikhaylov _Stiltsoft_]

Hello @Nicolas Goutte,

If you use Confluence Cloud, you should definitely expect no issue already, as we have released the corresponding fix. Could you please check and confirm?

[Nicolas Goutte]

I confirm. Thank you

[Laurie Sciutti]

Hi @Nicolas Goutte ~ this should work:

[Nicolas Goutte]

Hi @Laurie Sciutti 

It could have been a good I idea, but I can't edit selection values from Atlassian Spreadsheet, I can only select cells.
Your proposition is from Excel, not Atlassian Spreadsheet.
I tested it with Edge and Chrome ...

How could I find a way to edit in order to insert the '$'?

Thank you,

Nicolas