Conditional formatting variation

[JChandler22]

Is there a way to use Excel's conditional formatting tool to format a cell based on the value of a different cell without using VBA?

For example, cell A1 is a true/false cell.


If A1 is true, highlight cell B3 yellow. Otherwise, leave it unhighlighted.

Is vba my only option here?

[daddylonglegs]

You can use the "formula is" option in conditional formattting [selected from the drop down list]

Then just use formula

=A1=TRUE

select yellow pattern > OK

[JChandler22]

Perfect, so simple. Works great.

Thanks a lot!