Thread: cell background color and cell text color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default cell background color and cell text color
You can do this with Conditional Formatting.

Select the range of cells to apply the format to, then select "Conditional
Formatting" from the Format Menu (or in the Styles section of the Home Tab in
xl2007).

HTH,
Elkar


"Jeff Klein" wrote:

Is there a way to use the "If" function to change the cell properties?



Reply With QuoteReply With Quote