Help with COUNTIF function

[mbetts]

Hello,

I have the following spreadsheet set up so I can look for changes since the last update in a database:

In the first 3 columns (A-C) I have Reference, Date, Time.

In the next 3 columns (D-F) I have Reference, Date, Time.

I then have 3 more columns which use a simple =A2 =E2 (Reference column H), =B2 =F2 (Date column I), and C2 = G2 (Time column J) (which returns a value of TRUE or FALSE so I can spot any changes in the dates or times columns as "FALSE").

Can anyone provide a "conditional formula" that will highlight the reference in column E2 if the value in either J2 or K2 is "FALSE" (I can then drag the formula down) ?


Thank you in advance

 

[SteveO59L]

Something along the lines of

=or(j2=false,k2=false)

 

[mbetts]

Excellent, thanks Steve. Have a great weekend )