Conditional Formatting Question

[JTL9161]

I have 4 columns A,B,C,D, Row 1. If any or all cells have data in them I need to color fill columns F,G,H in the same row. Subsequently if any or all cells in columns F,G,H have data in them I need to color fill A,B,C,D in the same row.

I can get it get it to work if A,B,C,D have any or all that F,G,H are colored out but when I try to do the same in F,G,H I can block out A,B,C,D only if F is filled. If F is blank and the others are filled A,B,C,D are not colored out.

Any help will be appreciated.
James

 

[ValuationMan]

What formulas are you currently using? Based on your description, you might have an issue with absolute and relative references.