Conditional Format (exclude 0)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 24 Aug 2007 16:32 GMT

Excel2003 ... Range A6:G6 contains Formula's

Cell A6 contains a Name (returned by formula)
Range B6:G6 contains values 0 to 7 (returned by formula & may repeat)

I wish to set conditional formatting in Cell A6

Condition = when value in Range B6:G6 is >=1 & <5.

Thanks ... Kha

Reply to this Message

Farhad - 24 Aug 2007 18:42 GMT

Hi,

What do you want to happen when your condition has met?????

Thanks,

Signature

Farhad Hodjat

> Excel2003 ... Range A6:G6 contains Formula's
>
[quoted text clipped - 6 lines]
>
> Thanks ... Kha

Reply to this Message