Formula for Conditional Formatting

[ranaray]

I am struggling with a formula that i want to work in conditional formatting.

I want the cell A1 to highlight if the value of B1 is <3. However the cell should not highlight if there is no value in A1 or if teh value is 0

Thanks
Rana

 

[Asheesh]

Hi - see the attached

 

[Nebu]

Hi:
Find the attached.

Thanks

 

[ranaray]

Hi Asheesh,

Rule 1 : this works perfectly : this is cell A1 turns red if value of cell B1 is <3

Rule 2: I need the cell A1 to highlight only if I put a figure in cell A1 which is more than 0 else it should remain as is. This is the bit thats not working.

Hope I was able to explain well.

Rana

 

[Asheesh]

@ranaray

Sorry, I miss read your question

There is a solution suggested by Nebu as well..I am sure that will work..

Otherwise, I shall rework on the solution..please confirm..

 

[ranaray]

Thanks Nebu : now I need to get this to work for coloumn A based on values in coloum B