How to Put Lighthouse Indicator in Excel

Post author:California18
Post published:May 13, 2023
Post category:U.S.
Post comments:0 Comments

One way to facilitate the interpretation of multiple data and extract indicators in an Excel spreadsheet is to use the conditional formatting tool, which allows you to define rules and create signals for goals, values and percentages. With this tool, you can create conditionals based on cell values to format fields with colors and visual indicators — like inserting a beacon.

Excel’s conditional formatting makes data easier to read and highlights the most important information in a table.

How to Put Lighthouse in Excel

A beacon can be configured using Excel’s conditional formatting tool based on a column of cells with numerical values.

To exemplify this tutorial, let’s consider a lighthouse that indicates the green signal for a percentage lower than 30%, yellow for values between 30% and 60%, and red for a percentage above 60%. Our lighthouse uses column F as the basis of percentage values.

Create a column to serve as a Lighthouse;
Fill in the cells of this column with the letter “n” lowercase;
Change the font of the Lighthouse column to “Webdings”;
Select the first cell with value “n” from the Lighthouse column;
In the Home tab, access “Conditional Formatting”;
Click on “New Rule” to add a new condition;
Select the “Classic” style option;
Choose “Use a formula to determine which cells to format”;
In the rule description, enter =$F3<=0.3 and set the green formatting color;
Repeat steps 5 through 8 to enter another rule;
In the rule description, type =$F3<=0.6 and choose formatting in yellow color;
Repeat steps 5 through 8 again to add another condition;
type it =$F3>0.6 in the description and the red color for the text;
Select the first value cell of the Lighthouse column and click on the “Brush” tool;
Drag formatting to the remaining cells in the Lighthouse column to apply the rules.