I am trying to format cells in Column B,C,D,E with green fill and dark green text, based on a rule that a cell in Column F contains a date. Anyone can help out? I have attached an example sheet.
I am trying to format cells in Column B,C,D,E with green fill and dark green text, based on a rule that a cell in Column F contains a date. Anyone can help out? I have attached an example sheet.
Last edited by q988988; 02-26-2020 at 12:19 AM.
Attachment 664568 Here is a photo of an example.
1. Select cell B5.
2. Set up this CF formula rule: =$F5<>""
3. Set the formatting required.. In the Applies To box, set the range e.g. =$B$5:$E$22
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
To be on the safe side, I would add =AND($F5<>"",TYPE($F5)=1) (avoiding any entry different from a number ( which is what dates really are))
Last edited by Pepe Le Mokko; 02-26-2020 at 04:28 AM.
Thank you.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks