Thread: Changing cell color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Changing cell color
Hi Kas

You van use CF
http://www.contextures.com/xlCondFormat01.html

Select b1:Z1 ?

And use this formula
=A1<B1

Choose the format you want

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kas" wrote in message ...
I need to either write a macro or a formula that will automatically change
the font of a cell if it is greater than the previous cell. For example, if
a1 = 3 and b1 = 4, I need 4 to be a different color. Can this be done? Any
help would be greatly appreciated.


Reply With QuoteReply With Quote