LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 86
Default cell vlue based on cell back colour

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill cell colour based on input in another cell Dan Wood[_2_] Excel Worksheet Functions 2 August 20th 09 06:28 AM
how do i change cell text colour based on value in other cell Oscarrot Excel Worksheet Functions 2 July 20th 09 03:21 PM
Use a vlue of a cell for the sum range jimjudd New Users to Excel 2 July 2nd 08 08:31 PM
Excel spreadsheet change colour of cell back ground depending on d Nataliec Excel Discussion (Misc queries) 1 September 12th 07 12:12 PM
Sum contents of comments based on back fill colour Arran Excel Discussion (Misc queries) 7 December 8th 06 08:07 AM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"