Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2019, 08:53 AM
neosylcolaf neosylcolaf is offline IsHighlighted? Windows 8 IsHighlighted? Office 2019
Novice
IsHighlighted?
 
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.

IF(IsBold(C5),"1","0")
Attached Images
File Type: jpg isBold Excel issue.JPG (9.6 KB, 11 views)
Reply With Quote
  #2  
Old 05-23-2019, 05:23 PM
Alansidman's Avatar
Alansidman Alansidman is offline IsHighlighted? Windows 10 IsHighlighted? Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

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
Reply

Tags
formulas, if function, is function

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 AM.


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