is there anyway to "save" or "pin" a conditional format to the quick access bar?
i utilize a conditional format all the time where i want Positive percentages in green, and negative in red (for stock market purposes). tedious to always have to set it. im not really looking for a macro either. just looking for a button or something i can press to format it the way i want it.
Dunno how to do that, but you can create a new cell style with custom number format [Green]0%;[Red]0% and select it from the style gallery. Color selection is limited.
Entia non sunt multiplicanda sine necessitate
shg, im not sure how to do that...can you guide me? would this be a method where i could click a button and it would format my cell the way i described?
>> im not sure how to do that...can you guide me?
Click Style Gallery > New cell style, apply the custom number format shown.
>> would this be a method where i could click a button and it would format my cell the way i described?
No, you can't have CF as part of a style.
Last edited by shg; 03-02-2020 at 01:52 PM.
@eugchen;
You can apply the custom format given in message #2 to a cell in a new Excel file, save the file as a template in your XLSTART folder giving the name "Book.xltx".
In this way, the custom format will be available for you whenever you need.
The location of the XLSTART folder depends on your Windows version.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks