Red Gig

Once you've got the hang of the basics in Excel you'll normally require the use of the IF function to carry out slightly more complex actions. At first glance, the IF function can appear a little daunting but after some time it'll become second nature and enable you to create spreadsheets that will begin to deliver significant benefits. The IF function usually incorporates 3 elements (arguments), the logical_test, the value_if_true and the value_if_false. You'll notice from the square brackets below that the last two arguments are optional. If you are new to the IF function I would recommend supplying all 3 arguments to help understand what the formula is doing. logical_test This part of the formula, is usually a comparison, the simplest form is A1 = B1 where A1 and B1 are 'tested' to see if they match. The output of this test is one of two possibilities, true or false. Some other logical tests could be A1 > B1, A1 = "apples" or even A1 = B1 = C1. T

Dates Using conditional formatting for dates is an extremely useful way of bringing some visual management to schedules, diaries and other tools where dates are used. The ability to dynamically highlight today, tomorrow or the current week is something that would be of benefit to the majority of workplaces. Excel has the functionality to do this with just a few clicks using the 'Format only cells that contain', 'Dates occurring option. It can be configured to highlight dates relating to,  Yesterday,  Today,  Tomorrow,  In the last 7 days,  Last Week,  Next week,  Last month,  This month,  Next month In the following examples, I'm using a list of dates that begins at the start of the next month and decreases by a day for each subsequent row. Day related conditional formatting Highlight yesterday with a different colour Highlight today with a different colour Highlight tomorrow with a different colour Week related conditional formatting Highlight date in the previous 7 da