![]() ![]() Select the fill style for the cells that meet the criteria. ![]() From the Format Rules section, select Custom Formula and type in the formula. The TEXT function then converts the number to a readable date by first changing the number to text, and then using 'dddd, mmmm dd' to control how the date appears-'Friday, January 20.' Make sure you surround 'ddd, mmmm dd' date format with double quotes, and notice how the format uses commas and spaces.The Apply to Range section will already be filled in.Highlight the cells you wish to format, and then click on Format > Conditional Formatting.The process to highlight cells that contain an IF Statement in Google Sheets is similar to the process in Excel. To format the “OnTime” cells to green, you can create another rule based on the same range of cells.The formula entered will return TRUE when the cell contains the word “Overdue” and will therefore format the text in those cells with a background color of red. Click Apply to apply the formatting to your selected range and then click Close.Click OK, and then OK once again to return to the Conditional Formatting Rules Manager. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |