Thread: Changing the color of cells by formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Changing the color of cells by formula
You will have to use Conditional formatting (on the Format menu) with
the Formula Is option rather than Cell Contents Is. In XL 2003 and
earlier you are limited to 3 conditional formats per cell.

Hope this helps.

Pete

On Aug 24, 12:19 am, "Emerogork" <u36894@uwe wrote:
I wish to change the colors of cells relative to values in other cells in the
same row. This is to be done automatically by formula. Can this be done?


Reply With QuoteReply With Quote