Forum Discussion
How do I format one cell based on values in others cells?
Hello, Is it possible to format cell J3 so that it shows in a different color (or ideally with an icon) if column B contains todays date?
Select J3.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=COUNTIF(B:B; TODAY())
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
Thank you! That works.
Seems like its not possible to add Icon sets though when you use a formula to determine which cells to format. Is that right?
That is correct - icons only work based on the value of the cell itself.