1
The Master Guide to Creative Career Evolution
Jerri Barr edited this page 1 month ago
Auto-Generate Post Dates with a 5-Column Date Formula Place the first Monday of the Slap on a traffic-light palette to the Status column so you can eyeball bottlenecks in 0.3 s per row. Grab the entire Status range (say D2:D100), dive into Format › Conditional formatting, switch to "Custom formula is", and drop =D2="Live". Set background #00B04F and font #FFFFFF. Stack two more rules: =D2="Review" with #FF9C2A and #000000