Conditional Formatting - To change the color of row,if any cell match is FALSE

Sir,

I am preparing a monthly from an Excel file export from SharePoint ( attached the template copy )

Report have 8 columns and all are connected each other .

Column B : Inspection Category is connected with Column D : Finding Category
If on Cell B2 : Health_Safety , on Cell D2 not Health_Safety, then Color of entire row have to change

Color of Entire row have to change according to below findings

1. If Cell C2: Negative , On cell F2, if F2= Positive Observation

2. If Cell C2 : Positive , On cell F2, if Cell F2 not equal to Positive Observation

3. If Cell C2 : Positive , On cell F2, if Cell F2 equal to Positive Observation & on Cell G2= Yes

4. If Cell C2 : Negative, G2: Yes, then Cell H2: cannot be empty, if showing

5. If Cell H2 have value, then I2 , Cannot be empty and value of I2 start with first word of H2
Eg : If H2 : Lifting, then value of I2 start with Lifting.



Thanks in advance

Thanks for your reply, Please find attached new excel sheet with color change

Thanks for your reply,

Is possible to change Column A color, if any of the column color changes from B to H

Please find attached new excel sheet to make more clarity.

In excel sheet you can find comments in the cells, where selected wrong value ( Highlighted in Yellow and Red font ).

Any update ?

It is working, Thanks, for your great support

this support reduces my lot of stress and time while preparing a report.