# CELL FORMATING

• ### Question

• Hi,

I want to format Column G or row from A to Z  to fill cells red, If cell in Column D contains a value and cell in Column G is empty.

=AND(D:D<=1,G:G="") This formula is not working.

regards,

dockhem

Tuesday, November 25, 2014 12:08 PM

• Below is working for me.

Formula in conditional formatting -> =AND(\$D1<>"",\$G1="")

and Applies to range -> =\$G:\$G

Regards,

Amol Gargote

• Proposed as answer by Wednesday, November 26, 2014 5:29 AM
• Marked as answer by Sunday, December 7, 2014 7:10 AM
Tuesday, November 25, 2014 2:03 PM
• Hi Amol Gargote,

Thank you,

=AND(\$D1<>"",\$G1="") did not come with proper result though, I changed to

=AND(\$D1>1,\$G1=""). Now it is ok.

regards

dockhem

• Edited by Wednesday, November 26, 2014 6:50 AM
• Marked as answer by Sunday, December 7, 2014 7:10 AM
Wednesday, November 26, 2014 6:49 AM

### All replies

• Below is working for me.

Formula in conditional formatting -> =AND(\$D1<>"",\$G1="")

and Applies to range -> =\$G:\$G

Regards,

Amol Gargote

• Proposed as answer by Wednesday, November 26, 2014 5:29 AM
• Marked as answer by Sunday, December 7, 2014 7:10 AM
Tuesday, November 25, 2014 2:03 PM
• Have you tried: AND(D:D<>"", G:G="") ?

I must say i tried via Conditional formatting and could not get this to work. The regular Function does work but the formatting did not. I then placed the function in Cel A1 and applied conditional formatting based on the outcome of cel A1.

In short:

Cel 1: AND(\$D:\$D<>"", \$G:\$G) -> This evaluates to true or false

Conditional formatting A-Z based on formula =\$A=true

This works as expected. Might not be the solution your hoping for but we'll see if other people experience the same.

Maurice

Tuesday, November 25, 2014 2:25 PM
• Hi Amol Gargote,

Thank you,

=AND(\$D1<>"",\$G1="") did not come with proper result though, I changed to

=AND(\$D1>1,\$G1=""). Now it is ok.

regards

dockhem

• Edited by Wednesday, November 26, 2014 6:50 AM
• Marked as answer by Sunday, December 7, 2014 7:10 AM
Wednesday, November 26, 2014 6:49 AM
• Thank you,

AND(D:D<>"", G:G="") did not work for me.

regards

dockhem

Wednesday, November 26, 2014 6:52 AM