Drop down lists over numbered cells

[mrhk22]

Hi there, some advice would be appreciated.
I have applied conditional formatting over a table with sales figures, so that figures below a certain level appear red.
I wanted to apply data validation so that sales people can click on each red cell and indicate the status from a drop down selection.
Is there a way to set this up so that the original number/color can still be seen after the drop down selection has been made?
Or any better way to approach this?
Thanks.

 

[Toadstool]

Hi Mrhk22,

You can change the Conditional Format to identify a status entry and so maintain the color but it would overwrite the number.

MRHK22.xlsx
	G	H	I
5	2	33	77
6	88	33	StatusB
7	12	45	88
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G5:I7	Expression	=OR(G5<20,ISTEXT(G5))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
G5:I7	List	StatusA,StatusB,StatusC