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: 331
Default cell auto format

If i have something in block B2, i want something in block A2 to change to a
certain font and fill color. I.E. If it were to say 'A' in b2 then i want
it to be black font and a green fill in A2; and if it said 'B' in B2 i want
it to be black font with a red fill in A2.

is anyone able to help me with this or know where i can look?
 
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 format cell to enter data alphabet in column dee Excel Worksheet Functions 1 May 10th 07 05:52 PM
auto-hide rows, cell format (# and @), update cell refs, shade cel Mo2 Excel Discussion (Misc queries) 0 April 17th 07 03:44 AM
Stop cell auto format in Excel - SOLUTION! [email protected] Excel Discussion (Misc queries) 0 September 1st 06 05:14 PM
Excel Auto-Format cell to email format Please Help Me Excel Discussion (Misc queries) 1 March 23rd 06 05:15 PM
How to format a number cell to auto count 1 up on file open Joevee Excel Worksheet Functions 0 February 1st 06 05:00 PM


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