Microsoft Office Forums IsHighlighted?

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 05-23-2019, 08:53 AM
neosylcolaf neosylcolaf is offline IsHighlighted? Windows 8 IsHighlighted? Office 2019
Join Date: May 2019
Posts: 1
neosylcolaf is on a distinguished road
Default IsHighlighted?

Why is isBold a formula option and not other text effects, such as IsHighlighted or IsItalic?

For example, we want to make selected data more readable by making it highlighted instead of bold. I thought I could simply change swap the word "Bold" for "Highlighted," but instead I got the #NAME? error. Our current code is below.

Attached Images
File Type: jpg isBold Excel issue.JPG (9.6 KB, 7 views)
Reply With Quote
Old 05-23-2019, 05:23 PM
Alansidman's Avatar
Alansidman Alansidman is offline IsHighlighted? Windows 10 IsHighlighted? Office 2019
Advanced Beginner
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 34
Alansidman is on a distinguished road

I don't believe that IsBold is a regular Excel Function. Where did you find this? I am guessing that is a User Developed Function (UDF) that someone created in VBA. That being the case, a UDF could be developed for Italics and Highlighted.
Reply With Quote

formulas, if function, is function

Thread Tools
Display Modes

All times are GMT -7. The time now is 07:33 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd. is not affiliated with Microsoft