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
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.

1 reply

rramesh99 Posts 1 Registration date Saturday May 21, 2016 Status Member Last seen May 21, 2016
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
0