Conditional formatting

[vinnydarat]

was hoping to set up a spread sheet where i can input either a yes or no into a cell and depending on whih option, it could change the formatting (i.e. if i picked yes, the Y would show as bold, red text, light yellow background on that cell. Where as if i chose N, then the text would be italics, blue with light green background on that cell)

i hope that makes sense

 

[dafan]

It's indeed called Conditionnal formatting and can be found under the Format menu.

Cell Value ; Equal too; ="Y"
Click Format
Bold, Color = Red, Pattern = Yellow

click Ok, Add >>
Repeat for "N"

 

[vinnydarat]

Dude, you are a legend, that is exactly what i was looking for

 

[dafan]

It is pretty much basic Excel knowledge, but yes I also asked this on a forum when I started with Excel :D