Excel quicky

[adamlewis01]

is there a way of typing in a cell for example "red" and the box will turn red?

adam

 

[iain187]

conditional formating, if you can find that in the menu, it should be self explanatory.

 

[C.J]

conditional formating, if you can find that in the menu, it should be self explanatory.

+1

Set it up in the conditional formating area.

If Cell = 'RED' (Then format the colour of the cell)

 

[adamlewis01]

no luck tbh its only talking about values and not words.

 

[koi]

click on the cell then go to Format->Conditional Formatting

 

[LaurenF]

no luck tbh its only talking about values and not words.

Is there not a dropdown where you can select specific text? I've not got Excel at work so can't look myself.

EDIT: Ah actually, thinking about it, that's on Excel 2007.....

 

[koi]

no luck tbh its only talking about values and not words.

if you do 'Cell Value is' and 'equals to' then put your word in the next box it should work, you can then click 'add' to add extra conditions

 

[iain187]

this works for me:

it's pretty similar in pre-office 2007 iirc

 

[adamlewis01]

a few people are confused i need the cell to turn red not the word? i have tried all that but it was doing silly things like....when i type red it stays normal but when i click ot of the box it changes to red? also clicking "equals to" and "red" wont work for me

 

[The Boosh!]

lewis... follow the above pic that ian has shown you... but click the format tab button then click on the patterns tab. click the red colour... change your font to a colour of your choice. it will work

 

[mradam87]

Make sure the word Red is in quotation marks: "Red" in the conditional formatting box