Conditional Format

[sirpsycho]

Hi people



How to do in conditional format for below query.

When I input in cell D3 with 1 and E3 with 7 or below, the cell of E3 will be red color. when I input in cell D3 with 1 and E3 with 8 and above, the cell of E3 will be green. When I input in cell D3 with 2 and E3 with 15 and below, the cell of E3 will be red color. when I input in cell D3 with 2 and E3 with 16 and above the cell of E3 will be green.

your help is much appreciated

Thanks

[zbor]

Select your cells and format them with green color.

Then in CF write this formula: =E3/D3<8 for red color