Is there a way I can check if two cells are the same in a table on Confluence?

[Ankit Patel]

Easy to do on Excel, but is there functionality available on Confluence to validate if two cells in a table are the same, and use conditional formatting to highlight differences etc?

My goal here, simply put is for one cell to have a live feed on a particular version of a database. Then, a second column that has the version I've actually tested for - and then a third column to show "green" that they both match. If, for example, the live version has updated, it'll be different to what i've manually put in for the version I have tested for...then it'll highlight the fact I need to retest.  Hope this makes sense?

[Stiltsoft support]

Hi @Ankit Patel ,

We can suggest trying our app - Table Filter and Charts for Confluence.

Wrap your table in the Table Transformer macro and use the following SQL query:

SELECT *,
CASE WHEN 'Column 1' = 'Column 2'
THEN FORMATWIKI("{status:colour=Green|title=Green}")
ELSE
FORMATWIKI("{status:colour=Grey|title=None}")
END
AS 'Status'
FROM T*

You may also wrap the Table Transformer macro in the Table Filter macro and filter your result table by the new 'Status' column.

And if you prefer to work with Excel-like functionality, you may check the Table Spreadsheet macro that is also provided by the app.