#1
|
|||
|
|||
Conditional Formatting not coloring the cells
I set up a status column and want to have Not Started (red), In Work(blue), and Completed (green) as drop down options for cells D9-D19. Did I set it up correctly (image attached) Thanks. |
#2
|
||||
|
||||
Instead of:
=$D$9:$D$19="Completed" try: =$D9="Completed" similar for the others. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting that highlights cells when there was a change in another column | Marcia | Excel | 4 | 04-28-2019 07:34 AM |
How to highlight the cells using conditional formatting? | LearnerExcel | Excel | 1 | 01-01-2019 01:43 AM |
How to highlight cells using Vlookup / conditional formatting | mikehk | Excel | 2 | 09-18-2017 07:30 PM |
Conditional Formatting for Cells Containing Formula | Gillian623 | Excel | 1 | 12-09-2016 11:03 PM |
Conditional Formatting- Only format cells once data is entered | chart3 | Excel Programming | 1 | 12-15-2015 11:26 AM |