Conditional Formatting in Excel 2010

Closed
Jules10 - 13 Dec 2015 à 16:26
rramesh99 Posts 1 Registration date Saturday 21 May 2016 Status Member Last seen 21 May 2016 - 21 May 2016 à 06:46
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.
Related:

1 response

rramesh99 Posts 1 Registration date Saturday 21 May 2016 Status Member Last seen 21 May 2016
21 May 2016 à 06:46
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