Conditional Formatting based on another cell (2007)

Topic

New Reply

How do you get Excel 2007 to format a specific cell (say C1) based on whether or not A1 is populated (say A1>0).

I love the new conditional formatting of 2007, but can’t figure out how to do this process that is easily completed in earlier versions?

Reply | Quote

Replies

Select New Rule or Manage Rules, then New Rule from the Conditional Formatting dropdown.
In the New Formatting Rule dialog, choose “Use formula to determine which cells to format”.

Reply | Quote