Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 23rd 07, 03:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 19
Default Condition based on cell colour

Without using VB is there a way to create a condition based on a cell
colour, i.e if Cell A3 is grey but cell A1: A8 (excluding A4) is
green, then create a condition in B1:G8 that if any of the cells A1:A8
are grey, that the corresponding cells in that row go grey also?

i.e if A3 is grey B3:G3 go grey. If As then goes green, B3:G3 go
green too. If A8 is then grey, then B8:G8 go grey.

Cheers

Rich


  #2   Report Post  
Old March 23rd 07, 05:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default Condition based on cell colour

No, you cannot change colours using standard worksheet functions - you
would need to use VBA.

Sorry,

Pete

On Mar 23, 3:27 pm, "Richhall" wrote:
Without using VB is there a way to create a condition based on a cell
colour, i.e if Cell A3 is grey but cell A1: A8 (excluding A4) is
green, then create a condition in B1:G8 that if any of the cells A1:A8
are grey, that the corresponding cells in that row go grey also?

i.e if A3 is grey B3:G3 go grey. If As then goes green, B3:G3 go
green too. If A8 is then grey, then B8:G8 go grey.

Cheers

Rich



  #3   Report Post  
Old March 25th 07, 04:23 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 19
Default Condition based on cell colour

On 23 Mar, 18:17, "Pete_UK" wrote:
No, you cannot change colours using standard worksheet functions - you
would need to use VBA.

Sorry,

Pete

On Mar 23, 3:27 pm, "Richhall" wrote:



Without using VB is there a way to create a condition based on a cell
colour, i.e if Cell A3 is grey but cell A1: A8 (excluding A4) is
green, then create a condition in B1:G8 that if any of the cells A1:A8
are grey, that the corresponding cells in that row go grey also?


i.e if A3 is grey B3:G3 go grey. If As then goes green, B3:G3 go
green too. If A8 is then grey, then B8:G8 go grey.


Cheers


Rich- Hide quoted text -


- Show quoted text -


Would you able to give me a started for how I would use VB please? I'm
familiar with macros and very simple VB code.

Cheers

Rich



Reply
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
auto change cell text colour resulting from a condition Chinaman Excel Worksheet Functions 2 December 14th 06 01:19 AM
Is there a way to delete a cell value based on a condition? Peanut Excel Discussion (Misc queries) 2 October 2nd 06 09:55 PM
Fill a cell based on a condition being met confused teacher Excel Worksheet Functions 3 July 5th 06 08:29 AM
Change the Row Colour, using a cell condition belgarth58 Excel Discussion (Misc queries) 1 February 7th 06 07:42 PM
Cell text based on 4 condition test Bob Wall Excel Worksheet Functions 3 November 16th 05 07:34 PM


All times are GMT +1. The time now is 05:16 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017