Simple Spreadsheet programming help

**theebookzoo** · 08-25-2008, 12:05 PM

Hello,
I have a spreadsheet that I need a m acro for, that will look at cell U3, if it is a 0 (zero) then hightlight cell C3 yellow. And so on, if U4 is zero, highlight U4..
Also look at the cells below,
cell U4, if it is a 0 (zero) then hightlight cell D4 yellow. And so on...
Can anyone help me with this?

The macro will be behind a button on the spreadsheet. I dont know if that makes a difference or not.
Thanks!!!

**MartinShort** · 08-25-2008, 02:35 PM

You don't need to use a macro, use conditional formatting instead.

1) Select Cell C3, and choose conditional formatting from the Format menu.

2) Change Condition 1 to "Formula is".

3) In the Formula box type

Please Login or Register  to view this content.

4) Change the required format to Yellow Cell Shading.

5) Copy this formatting down the entire range you want to select.

If you need to exclude null cells, use

Please Login or Register  to view this content.

as the suggested formula in point 2) interprets Nulls as Zeros.

**arthurbr** · 08-25-2008, 03:27 PM

Hi, as you haven't answered my last message about what the thread title should be, I am closing this thread.
Please feel free to open an new one with a relevant title
Cheers