Did you try to use the words greencondition and redcondition instead of
actually inserting the relevant conditions? If so, you will get #NAME? if
you haven't defined greencondition and redcondition.
--
David Biddulph


"Esradekan" wrote in message
...

Doesnt work. Comes up with #NAME?

Any idea of the problem?

Esra
TIA

On Apr 3, 3:30 am, Gord Dibben <gorddibbATshawDOTca wrote:
You have conditions in column A that color the cells.

Use those conditions in B and C

B1 formula =IF(A1=greencondition,1,"")

C1 formula =IF(A1=redcondition,1,"")

Gord

On Thu, 1 Apr 2010 17:52:29 -0700 (PDT), Esradekan
wrote:



On Apr 2, 4:16 am, Gord Dibben <gorddibbATshawDOTca wrote:
Are the colored cells in A1:A35 the result of Conditional Formatting?

Are they manually colored?

What numbers do you want in column B based on colors in column A?

Gord Dibben MS Excel MVP

On Wed, 31 Mar 2010 16:37:52 -0700 (PDT), Esradekan

wrote:

On Mar 30, 9:03 pm, Esradekan wrote:
Cell Range A1:A35 are different colours (Red, Green, Blue -
depending
on their value)
I want B1:B35 to show a number, based on the colour of adjoining
cells.
Is there a simple formula that will allow me to do this?

TIA (*-*)<
Esra

Nobody able to give me an answer?

Esra- Hide quoted text -

- Show quoted text -

HI,

Yes they are the result of conditional formatting and all I want if
they are green to show a number 1 in the adjoining cell in the B
column and if they are red, a number 1 in the C column.

I am trialling the beta version of office 2010 at the moment but
normally use 2007.

TIA
Esra
(*-*)<- Hide quoted text -

- Show quoted text -