Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Conditiona format based on format of another cell

If A1 is conditionally formatted use the same rule to apply cf to C1.

If A1 isn't conditionally formatted then why is A1 colored green?

Use the logic of *WHY* A1 is green to apply the cf to C1.

--
Biff
Microsoft Excel MVP


"Tami" wrote in message
...
can i conditionally format a cell based on the shading of another cell.

e.g. i cell A1 is green shade C1 green.



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
Sumif based on cell format Fun Dan[_2_] Excel Worksheet Functions 2 September 11th 09 06:40 PM
Conditiona format Sverre Excel Discussion (Misc queries) 0 April 27th 09 01:10 PM
Conditional Format based on other cell [email protected] Excel Discussion (Misc queries) 1 March 1st 07 02:20 AM
how do i format a cell based on format of a range of cells? Chris Hardick Excel Discussion (Misc queries) 2 April 3rd 06 08:54 AM
New column based on row cell format peteracain Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM


All times are GMT +1. The time now is 07:01 PM.

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"