Help require for conditional formatting

Hi friends,

I have a conditional formatting as:

1. For cells ‘a, c, e, g, I, k’
If the value is <35 then
Should have a underline with red color and value automatic color
Problem: Here the underline and the value is colored red which I don’t want. For it I have created a macro but it’s not working as per requirement.

Here I want an amendment in the CF rule as:
If the cells ‘b, d, f, h, j, l’ contains a value then no underline and color red condition is require For cells ‘a, c, e, g, I, k’

If the value is >= 35 then no underline and color automatic.

2. For cells ‘m, o, q’
If the value is <18 then
Should have a underline with red color and value automatic color
Problem: Here the underline and the value is colored red which I don’t want. For it I have created a macro but it’s not working as per requirement.

Here I want an amendment in the CF rule as:
If the cells ‘n, p, r’ contains a value then no underline and color red condition is require For cells ‘m, o, q’

If the value is >=18 then no underline and color automatic.

Any help will be appreciated.

Thanking you in anticipation.

Hi,
Ok! Will you suggest me a conditional formula please?

Thank you.