View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Excel Macro: Changing Color of Cell

Kevin,

Select cell A44, for example. Then from the main Excel menu, choose Format / Conditional
Formatting.... and choose "Cell Value is.." and then one of the conditionals, and select your
limit or condition. Then set the format that you want by clicking the format button. Look in help
for examples.

HTH,
Bernie
MS Excel MVP


"kevinknight09" wrote in message
news:kevinknight09.2bx7rf_1154535607.6597@excelfor um-nospam.com...

Would you be willing to share the Conditional Formatting that you
referenced? Again I apologize for my lack of Excel and VB knowledge.
Thank you!


--
kevinknight09
------------------------------------------------------------------------
kevinknight09's Profile: http://www.excelforum.com/member.php...o&userid=37024
View this thread: http://www.excelforum.com/showthread...hreadid=567475