View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick[_10_] Rick[_10_] is offline
external usenet poster
 
Posts: 17
Default Conditional formatting to a different cell and it contains a formula

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