Conditional formatting with QUERY result in Google Spreadsheet

Question

I have a spreadsheet with 1 sheet of software version an another sheet of installation records. I want to do a conditional formatting that compares the version of in installation (on column F) to its know latest version number on another sheet ('Software Versions').

Current Solution

I came up with this formular initially:

=AND(F2<>"", F2=G2)

It works. But I need to maintain a column of QUERY results on G2:

=QUERY('Software Versions'!$A$1:$B$8, "Select B where A='" &D4& "' LIMIT 1")

Problem

Now I want to remove the G2 row altogether. I came up with this combined query:

=AND(F2<>"", F2=QUERY('Software Versions'!$A$1:$B$8, "Select B where A='" &D4& "' LIMIT 1"))

But I cannot save it because it is an "Invalid Formula":

Any way to actually do it?

Answer 1

Try use this formula:

=AND(F2<>"", F2=IFERROR(QUERY(INDIRECT("'Software Versions'!$A$1:$B$8"), "Select B where A='" &D4& "' LIMIT 1 label B ''"),""))

I was able to make conditional formatting with this formula.

Improvements

1. Use indirect to address another sheet
2. Use label B '' to prevent header appear as query result
3. Use iferror(..., "") to be sure no error occurs when no data is found with query