Results 1 to 4 of 4

after 1 week become yellow color

Threaded View

  1. #1
    Forum Contributor choy96's Avatar
    Join Date
    03-19-2010
    Location
    singapore
    MS-Off Ver
    Excel 2019
    Posts
    187

    after 1 week become yellow color

    i need a conditional format that can be fill in yellow color after 1 week, i have try use =A1<today()-7 apply to $A:$A fill yellow color, the blank cell also become yellow color, so i add 1 more conditional format =A1<today()-100 fill with white color , after that, i can not fill in yellow color manually into blank cell when i need to make a remark.

    Please see the attachment.

    thks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1