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

Similar discussions

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

26 responses
Product Key for Publisher 2010
SeriDahari -
jack4rall -

1 response