Conditional Formatting in Excel 2010
Closed
Jules10
-
Dec 13, 2015 at 04:26 PM
rramesh99 Posts 1 Registration date Saturday May 21, 2016 Status Member Last seen May 21, 2016 - May 21, 2016 at 06:46 AM
rramesh99 Posts 1 Registration date Saturday May 21, 2016 Status Member Last seen May 21, 2016 - May 21, 2016 at 06:46 AM
Hello,
In a celll that contains an if fumula which calculates if a cell is an "Actual" or Forecast" based on a drop down box selection, I would like to fill the cell red if the calculation is "Actual". If the calculation is "Forecast" I would like to fill the cell in amber. I can't seem to figure this one out. Can you please help.
In a celll that contains an if fumula which calculates if a cell is an "Actual" or Forecast" based on a drop down box selection, I would like to fill the cell red if the calculation is "Actual". If the calculation is "Forecast" I would like to fill the cell in amber. I can't seem to figure this one out. Can you please help.
Related:
- Conditional Formatting in Excel 2010
- Microsoft office 2010 free download - Download - Office suites
- Pdf and xps add in 2010 - Download - Other
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- Number to words in excel - Guide
1 response
rramesh99
Posts
1
Registration date
Saturday May 21, 2016
Status
Member
Last seen
May 21, 2016
May 21, 2016 at 06:46 AM
May 21, 2016 at 06:46 AM
IN CONDITIONAL FORMATTING SELECT "FORMAT ONLY CELL CONTAINING " OPTION
IF CELL VALUE IS EQUAL TO "ACTUAL" FORMAT CELL RED
IF CELL VALUE IS EQUAL TO "FORECAST" FORMAT CELL AMBER
IF CELL VALUE IS EQUAL TO "ACTUAL" FORMAT CELL RED
IF CELL VALUE IS EQUAL TO "FORECAST" FORMAT CELL AMBER