Hello, I need some help

  • Thread starter Thread starter peabushmartin
  • Start date Start date
P

peabushmartin

Hi, i have worked with excell for quite a number of years and wil
continue so in the future, but this other day i came across a sprea
sheet, where the background of the cells reacted to the letter yo
typed in the cell :confused: the person who showed me this didn
want to tell me, hes abit of a prick ;) but id like to know ho
this was achieved, anyone shed some light on this? was he usin
some sort of formulae, the nearest i could think of was a simple i
function
something i just made up =IF(*blank*:*blank) =(''A'',Put Re
background) of corse this doesnt work, but i cant see how he made th
cells background color change when a letter such as ''A'' was type
into it..

Thanks in Advance

Krgds Marti
 
aha, dont worry i just figured it out, from another thread,, Format
Conditional Formatting sweet.. :cool
 
Back
Top