Is it possible to fill cell color with Custom format (instead of conditional formatting)

hello excelers

the reason I preffer the custom format fill coloring is because it's better with speed .

thanks for any help

Thank you so much .

I think your best best would be a macro that runs upon opening that formats those cells and then is done.

Yes , this sounds awesome .
but I'm thinking like - perfect but how is that even possible ? because that's means that the macro will create the conditional formatting in the opening of the file and than cancel the conditional formatting but keep the fill painting of the cells, is it possible to do something like that , also is that possible to decide what ranking of priority this conditional formatting will be next to the others conditional formatting involved ?

thank you so much for having a look - this is my lines of conditional formatting:

for =$AC$5:$ETX$405
Those are the 3 different codes for CF I've got:

Please Login or Register  to view this content.

The first two are making the Gantt chart which uses "start date" column, "real progress date" and "finish date" and it shows on the rows in a lovely fashion how the different work goes on the chart , like gantt chart. the third code is to mark todays date on the column in yellow, it's long because I managed to change the dates from DAILY to WEEKLY to MONTHLY by having buttons that skip the date by 1/7/30 and this code mark the right date regardless if it's daily/weekly/monthly.
If I can have this third long code run in the start of the opening and then cancel the CF but keep the filling coloring that will be so efficient and might help greatly .

thanks for any tip.
you guys are so strengthen me, knowing with my endless projects that I have amazing people that might help from time to time, so lucky to get your help.

You can use Custom Formats to generate colours, but it is more limited than Conditional Formatting. It can only be applied to numbers, and basically you can have three conditions linked to the number being negative, equal to zero, or positive, although this can be relative to some other value. The choice of colours is also limited.

John McGimpsey had a good explanation of how to set it up, but the link I have for the site no longer seems to be valid.

Hope this helps.

Pete

Hi there,

Regarding what ChemistB wrote:

The third criteria contains TODAY() which is a volatile function and is the probably culprit.

the following code provides a simple way of referring to today's date without using a volatile function:

Please Login or Register  to view this content.

You can then re-write your code as follows:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M