LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 38
Default change styles of the cell if the value is one of other cells.

change style if the cell has the same value of one of other cell values.
for example
if A1 of sheet1 has the one value of B1:B7 then A1 is red.
How can I do that?

thanks.
 
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
New Cell Styles Steve... New Users to Excel 4 April 1st 07 04:56 PM
making copied cells change with change in original cell Jennifer Mcdermeit Excel Worksheet Functions 2 July 20th 06 04:58 PM
Excel: Toolbar button for Formatting cells to date STYLES etc Pauline from Perth Aus. Setting up and Configuration of Excel 0 June 6th 06 03:46 AM
How do I change a number in one cell to change a series of cells? lance559 Excel Discussion (Misc queries) 2 January 13th 06 08:56 PM
Line styles for Cell Borders Carl Excel Discussion (Misc queries) 1 December 2nd 04 04:28 AM


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