LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
kwkhoo
 
Posts: n/a
Default conditional formatting on specific text in cells

hi i have a problem

i want to do the following:

a b c d e f g h
1 3 3 3 3-3-3 3 4 5 3-4-5

d1 has formula =a1&"-"&a2&"-"&a3 to combine cells a1 to c1 to get 3-3-3
d2 has formula =e1&"-"&f2&"-"&g3 to combine cells e1 to g1 to get 3-4-5

how can i make the digit "4" and "5" be colored red to reflect the
changes from 3-3-3 to 3-4-5?

secondly, using the table above (perhaps related)

if i apply conditional formatting to cell g1, and it turns red
and i apply the formula "=g1" to a new cell I2 , it only shows the
value, but not the red color.
how do it get it to show red color in I2

i'm close to pulling my hair out. banging on the wall don't help.

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
Conditional formatting applicable to entire column jackalx Excel Worksheet Functions 1 May 26th 05 05:20 PM
Copying conditional formatting...HELP PLEASE!!!! trixiebme Excel Worksheet Functions 3 March 24th 05 01:53 PM
Conditional formatting based on text Gilles Desjardins Excel Worksheet Functions 8 February 16th 05 10:45 PM
bolding cells in conditional formatting Katherine Excel Worksheet Functions 1 December 7th 04 07:57 PM
conditional formating - Highlighting text cells based on sales res ANDREW_B Excel Discussion (Misc queries) 7 December 2nd 04 04:27 PM


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