Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Conditional formatting based on text | Excel Worksheet Functions | |||
bolding cells in conditional formatting | Excel Worksheet Functions | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) |