View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default cell vlue based on cell back colour

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 -