View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default Change a Value in a Worksheet

Conditional Formatting works great for this

"kdkat" wrote:

How do I change a the appearance of a value in one cell or the other in one
worksheet, based on the input of a cell in another.

ie: Have a column in worksheet one that if you type "W" want it to bold the
W in the cell in worksheet two. If you type "L" want it to bold the L in a
different cell in worksheet two.

Any help would be appreciated.