Conditional Formatting in Excel 2010 [Closed]

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

Posts
1
Registration date
Saturday May 21, 2016
Status
Member
Last seen
May 21, 2016

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!