Conditional Formating

[rizmomin]

Hello:

Please refer to attached sheet.

I need to use conditional formatting to perform the following.

If cell value in any of the cell in range G31:U31 is zero then highlight yellow in cell D1.


Please let me know if you have any questions.

Riz Momin

[JieJenn]

You might have to do it via VBA. In the worksheet module, insert

Please Login or Register  to view this content.

[AndyLitch]

My question would be , Why are you using Excel and asking questions like this ?

[JieJenn]

Change Range("D1").Interior.Color to Range("D1").Interior.Color = xlNone

My mistake.

[ConneXionLost]

Hi Riz,

Use this formula to set the Conditional Format for the D1 cell:

Please Login or Register  to view this content.

[JieJenn]

Duh. Ignore my post. ConneXionLost got it. I over thinking it.

[rizmomin]

Hi ConneXionLost:

Thanks a lot, your solution will work for me.

RM