ExcelBanter - Conditional Format (exclude 0)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Format (exclude 0) (https://www.excelbanter.com/excel-discussion-misc-queries/155657-conditional-format-exclude-0-a.html)

Ken

Conditional Format (exclude 0)

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

Farhad

Conditional Format (exclude 0)

Hi,

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

Thanks,
--
Farhad Hodjat

"Ken" wrote:

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

All times are GMT +1. The time now is 08:34 PM.