Conditional Formatting based on 4 cell factors

[camerong]

Hi guys,

Id like to have the conditional formatting setup in cell G6 so that it does the following:

1. When cell G6 is below a cell value of 18 cell G6 has a green fill.
2. When cell G6 is a blank cell G6 it has no fill.
3. When cell G6 is above a cell value of 18 cell G6 has a red fill.
4. When cell G6 is above a cell value of 18 AND cell E6 is not blank cell G6 has a yellow fill.

I can get the first 3 to work, but I cannot integrate the 4th point above without it overlapping the other conditional formatting I have in points 1-3 and subsequently not working.

See atatched screenshot of the worksheet.

Thanks guys.

 

[footoo]

What about if G6 = 18 ?

What formula are you using for point 4 ?

 

[Fluff]

For point use a formula & use this

=AND(G6>=18,E6<>"")

 

[camerong]

What about if G6 = 18 ?

What formula are you using for point 4 ?

Hi Footoo,

For points 3 and 4, those will apply if it is 18.00 or higher. For point 1 it would be 17.99 or lower. Sorry if that wasn't clear

Point 4 is the one that I am having issues getting to work

 

[camerong]

For point use a formula & use this

=AND(G6>=18,E6<>"")

Thanks Fluff,

That done the trick

 

[Fluff]

You're welcome & thanks for the feedback.