LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Conditional Format based on other cell

Hi, I have a situation where I have 2 Columns. Column1 has listing of
movies, and column 2 has Weekly Gross Data, so I want the column 1(the
name of the movie) to have green color if column2 has more than $20m,
but when I enter the number for Week2 (which would be my column3) I
want the column1 to change color automatically based on the number on
Column3. Can that be possible?

 
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
Conditional Format based on other cell [email protected] Excel Discussion (Misc queries) 1 March 1st 07 02:20 AM
conditional cell format based on cell in same row, previous column tamiluchi Excel Worksheet Functions 7 May 3rd 06 04:11 PM
Creating a conditional format for a cell based on another cell's v steve-o Excel Discussion (Misc queries) 2 October 26th 05 03:51 PM
Conditional Format based on contents of cell. dave m Excel Worksheet Functions 13 April 29th 05 01:12 PM
How do I do conditional format based on a cell with a formula? Justin Excel Worksheet Functions 9 December 17th 04 02:05 PM


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