Forum Discussion
Lisa_-_ExecAdmin
Jun 26, 2024Copper Contributor
Conditional formatting - using information from two columns
Hello everyone, I'm looking for some assistance with setting up conditional formatting in Excel. Here's what I need to accomplish: Highlight cells in Column D if the corresponding cell in Column C...
- Jun 26, 2024=AND($C2>=1, $D2<=TODAY())
as example
NikolinoDE
Jun 26, 2024Gold Contributor
=AND($C2>=1, $D2<=TODAY())
as example
as example
- Lisa_-_ExecAdminJun 26, 2024Copper ContributorThis worked perfectly! Thank you so much!