|
|
#1
03-14-2017, 03:10 PM
|
|||
|
|||
Conditional Formatting And Cell Fills
Hello I've created the attached Gantt chart. The conditional formatting gives all results in pink as a cell fill colour. My question is: How do I get the formatting to give a fill colour to be Green when Cells B10 to B29 are selected as Low, Orange when Cells B10 to B29 are selected as Medium, and Red when Cells B10 to B29 are selected as High? Thank you Last edited by Tartan Neil; 03-14-2017 at 03:12 PM. Reason: File not atached 
|
| Tags |
| conditional formatting, gantt chart |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional formatting of a cell
|
corsair_lancer | Excel | 3 | 12-10-2016 01:34 AM |
|
Question re: Conditional formatting (cell occurs after another cell)
|
Saywarder | Excel | 1 | 04-20-2015 11:29 AM |
| Conditional Cell Formatting: Alternating Cell Checks | corbott | Excel | 4 | 12-16-2014 01:51 PM |
| Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Mac OS X 
Office 2016
Threaded Mode