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 -
|