200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hello,
B4 has conditional formatting to turn colors when certain dates are reached against todays date, ie, 45 days, green, 60 days, yellow, 90 days, red. When I put a date in C4 I want the formatting to stop in B4, or to go white. When the new date is put in C4, the changing of colors needs to stop in previous cell. I need this to work for the whole work book.
Any help would be appreciated...........
Try something like this:-
=AND(TODAY()-$B4<45,LEN($C4)=0)This example looks for any content in $C4. If you need it to be a date you can change the condition to something like $C4>0
In conditional formatting, the formula should evalue to TRUE in order to trigger formatting. If it evaluates to FALSE nothing will happen. You can test the formula by pasting it into any worksheet cell.