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: 150
Default fill autoshape color with ref cell conditional formatting

I am creating a scorecard that will use a green/yellow/red signal for targets
met. Is there a way to have the fill color of the shape (a circle)
autopopulate based on the result and conditional formatting of a reference
cell?
 
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
autoshape color conditional formating Dennis Collins Excel Discussion (Misc queries) 11 May 16th 08 01:35 PM
Is conditional formatting or formula possible by cell color? J Billy Excel Worksheet Functions 2 June 30th 07 04:43 AM
Conditional Formatting and Cell Color nemadrias Excel Worksheet Functions 7 July 28th 06 05:01 PM
Cell Formatting Conditional On Other Cells Fill Color? [email protected] Excel Worksheet Functions 1 April 5th 06 10:05 PM
Cell color change without using conditional formatting Trese Excel Discussion (Misc queries) 2 August 26th 05 06:00 PM


All times are GMT +1. The time now is 06:06 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"