Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2007

Thu 16 Feb 2012, 10:54 Delegate Peter said...

Peter has attended:
Excel Intermediate course
Excel Advanced course

Excel

I need to insert a formula into a cell whereby when the value is equal to or less than a certain number the cell is shown in green but when it is greater than that number the cell is shown in red. How do I do this?

Thu 16 Feb 2012, 13:02 Trainer Anthony said...

RE: Excel

Hi Peter, thanks for your query. You use conditional formatting, not formulae to do this. There's a useful walkthrough here:

http://www.bettersolutions.com/excel/EPX299/LI129311911.htm

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Moving between split pane sections in a spreadsheet