Conditional Formatting not coloring the cells

JHalter · #1 01-18-2022, 11:41 AM

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.

p45cal · #2 01-18-2022, 06:11 PM

Instead of:
=$D$9:$D$19="Completed"
try:
=$D9="Completed"
similar for the others.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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