View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Need sample code

Hello -

I need sample code for the following scenarios:

If the color of the cell in column G is light green, then issue an error
message.
If the color of the cell in column G is white, make sure the corresponding
cell in column I is also white.

If there is a formula in the cell in column G, issue an error message.
If there is a Yes, No, or N/A in column G, make sure the corresponding cell
in Column I has text in it.

Any help will be greatly appreciated!

--
Sandy