excel conditional formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel Conditional formatting

resolvedResolved · High Priority · Version 2007

Christopher has attended:
No courses

Excel Conditional formatting

I want to change the icons used in Excel's conditional formating. For example, I want to show a green up arrow for values going up by 10% or more, and a red down arrow for values going down by 10% or more, with nothing showing for those in between. (I want to get rid of the orange arrow). Any help would be appreciated.

RE: Excel Conditional formatting

Hi..
I'm entering text into a cell and I simply want the colour of that text to change to blue when I exceed 250 characters.

should i use Cell Value OR Formula


Term Papers


 

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.09 secs.