cell background color and cell text color

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

Is there a way to use the "If" function to change the cell properties?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Colors of Cells set by Conditional Formatting 2
Changing Cell Color Based on Value 2
Does anyone have any suggesitons on how to do it for worksheet? 1
Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
How to extract separated text by many commas in Excel? 0
Formatting background colors 1
Sum Column Based on Cell Color 5

Back
Top