Previous Topic Next Topic

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

1 response

Answer 1 / 1
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses