View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
deelish deelish is offline
external usenet poster
 
Posts: 1
Default Conditional formatting using VB

I am a very novice programmer...actually to be completely honest, I kno
absolutely nothing about programming VB in Excel. What I would like t
do is write something that will help me do the following:

If cell A2 is greater than 30 and cell B2 says "yes", then have cell B
fill in red.

I would like to do this throughout the spreadsheet until there are n
more entries in either column, and I would like this to occu
automatically (i.e., without having to hit a button).

Thank you so much..

--
Message posted from http://www.ExcelForum.com