Excel conditional format

camioneur | 10:35 Thu 13th Mar 2008 | Technology

2 Answers

I'm having a senior moment here and can't remember how to colour a cell automatically depending on the text in that cell. I'm creating a holiday sheet and want to see easily who's off and when by the colour of the cell after I've put their name in the cell. Any help appreciated thanks

Reducing a URL to a word.

re computer

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by camioneur. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

camioneur

Question Author

Brain reconnected, problem solved

Bushwhacker

Highlight the cell range that you wish the formatting to apply to

From the Format drop-down menu select Conditional Formatting

Fill the boxes with Cell Value Is (box1) not equal to (box2) 0 (box3)

Click the Format Button, Select the Patterns tab, and select a colour.

This will have the effect of colouring any cells in your range that you type into.

BW

1 to 2 of 2

Do you know the answer?