View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default format adjacent cells

Conditional Formatting
=A1="x"
Format any color you want

"vic" wrote:

I need to format a cell (change it to red) when the cell adjacent to it
contains the character "x". I did try to look at tthe conditional formating
but colud not find a specific formula to do this, can anyone help me