View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default Conditional Formating another cell


Hi There,

Is it possible to change the contents of a cell based on a result of
ANOTHER cell.

Eg I would like to highlight in Red the word MICE (in Cell A3) because
cell B3 = 1
A B
Dogs 1
Cats 1
MICE 2

Thanks guys

Regards

D



*** Sent via Developersdex http://www.developersdex.com ***