PDA

View Full Version : Microsoft Excel question



Pogo2
6th July 2011, 17:14
Can you help me with this.............

In a spreadsheet I am wanting a cell to change colour if a value is reached or exceeded.

e.g say the limit is 1200, if it is below 1200 then the cell remains in a black font but if the number is 1200 or higher it changes to a red font for example.

Any ideas appreciated.

Cheers

Mark

Nasty
6th July 2011, 17:16
Can you help me with this.............

In a spreadsheet I am wanting a cell to change colour if a value is reached or exceeded.

e.g say the limit is 1200, if it is below 1200 then the cell remains in a black font but if the number is 1200 or higher it changes to a red font for example.

Any ideas appreciated.

Cheers

Mark

Use conditional formatting options.

Pogo2
6th July 2011, 17:22
Use conditional formatting options.

You are a gem!!

cowpoos
7th July 2011, 19:41
You are a gem!!

she annoyingly clever too!! :innocent: