DESCRIPTION
Merry Christmas Tree Fun In Excel RAND Function and Conditional Formatting
See how to create a Christmas Tree in Excel with the RAND function and Conditional Formatting and the F9 key.
Excel Is Fun
Excel Magic Trick 1307
DESCRIPTION Create Logical Formula to conditionally format only certain cell sin cross tabulated report using a Boolean Array Operation inside the SUM function: (00:13) Problem Set Up (01:25) Look at Logical Formula using AND and […]
Excel Is Fun
Excel Magic Trick 1230
DESCRIPTION Conditional Formatting: Highlight Table with Colour When Name Selected Learn how to create a Logical Formula to colour a table when a name is selected from a drop down: (00:13) Problem Overview (00:35) Keyboard […]
Excel Is Fun
Excel Magic Trick 1087
DESCRIPTION (08:00) Number Outside range with lower and upper hurdle. Numbers below the lower hurdle OR above the upper hurdle. (01:25) OR function. OR Criteria: only one TRUE is necessary for OR function to deliver […]
Leave a Reply
You must be logged in to post a comment.