Change Color of Cell in Excel Based on Value


Prev Tutorial Next Tutorial

Change Color of Font in Excel Based on Value

Excel allow you to change your font and cell color automatically on the basis of value. In other word we can say that we can change font and cell color automatically based on specific conditions.

Steps to Change Cell Color in Excel Based on Condition

  • Highlight your cell or range of cells.
  • Visit the Format menu, select Conditional Formatting.
  • In the Conditional formatting dialog, select Manage Rules.
  • Select new rules.
  • Use a formula to determine which cells to format.
  • In text area write your code or coditions
  • Click the Format.. button.
  • Choose your format options from the Font, Border and Fill tabs.
  • Choose Color for your cell.
  • Click OK.
change excel cell color based on condition change excel cell color based on condition change excel cell color based on condition change excel cell color based on condition
Prev Tutorial Next Tutorial

Google Advertisements

Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: hitesh.xc@gmail.com WhatsApp no. 8882538826

Yahoo Advertisements