I am working in excel 2000, and I need to know how to change a colour of a
cell when I enter a letter. Ie, if I put y for yes in a cell, I want to
change that cell to say red.
I am working in excel 2000, and I need to know how to change a colour of a
cell when I enter a letter. Ie, if I put y for yes in a cell, I want to
change that cell to say red.
Use "Conditional Formatting"
Click on the cell, do Format > ConditionalFormatting > CellValueIs > EqualTo
> Y > FormatButton > PatternsTab > choose red color block > OK > OK
Vaya con Dios,
Chuck, CABGx3
"paul42770" <[email protected]> wrote in message
news:[email protected]...
> I am working in excel 2000, and I need to know how to change a colour of a
> cell when I enter a letter. Ie, if I put y for yes in a cell, I want to
> change that cell to say red.
Thanks
It was most helpful.
Paul
"CLR" wrote:
> Use "Conditional Formatting"
>
> Click on the cell, do Format > ConditionalFormatting > CellValueIs > EqualTo
> > Y > FormatButton > PatternsTab > choose red color block > OK > OK
>
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "paul42770" <[email protected]> wrote in message
> news:[email protected]...
> > I am working in excel 2000, and I need to know how to change a colour of a
> > cell when I enter a letter. Ie, if I put y for yes in a cell, I want to
> > change that cell to say red.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks