EXCEL: Conditional Formatting Formula - Mark the cell red it's >10% of another cell value else, green

Question

EXCEL: Conditional Formatting Formula - Mark the cell red it's >10% of another cell value else, green

Please help me with conditional formula to mark a cell (Absent days)red if it's > 10% of cell from total days.

Example :  12% for 1/12/19 (3 cell) should be red and the rest should be green

DAY	1/1	1/2	1/3	1/4	1/5	1/6	1/7	1/8	1/9	1/10	1/11	1/12	1/13	1/14	1/15	1/16	1/17	1/18
Absent Days	0	1	1	1	0	2	1	1	0	0	1	3	1	1	1	2	0	16
Total Days	30	35	27	28	28	23	20	23	16	11	20	26	25	24	22	17	3	378

Answer 1

Let's say the absent days are in B2:AF2, and the total days in B3:AF3.

Select B2:AF2.

On the Home tab of the ribbon, click Conditional Formatting > Highlight Cells Rules > Greater Than...

In the box, enter the formula  =10%*B3

Select one of the predefined formats or click Custom Format...

Click OK when done.

Answer 2

Thanks for the solutions Hans but it highlights which is < 10% as well.

Anyways, I got an alternative resolution to this.

Thanks anyways,

Vin