Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This formula in B1 is: =SUBSTITUTE(A1,".","")
returns a number. (It removes a series of "dots" from the cell contents in A1.) Is it possible to have another cell C3 in that row become formatted, if the contents of B1 are displaying the number 3? So: A1 contains: " ............3" (without the quotes) B1 displays the number 3 We'd like C3 to be bold, lets say, or purple if a 3 is displayed in B1. Thanks, Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting - problem with text cell value from formula | Excel Worksheet Functions | |||
Conditional Formatting on cell with a formula | Excel Worksheet Functions | |||
Is conditional formatting or formula possible by cell color? | Excel Worksheet Functions | |||
Recognizing Cell Formatting To Use In A Formula Or Conditional For | Excel Worksheet Functions | |||
Conditional Formatting if cell content is a formula | Excel Worksheet Functions |