ExcelBanter - conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - conditional formatting (https://www.excelbanter.com/excel-programming/310025-conditional-formatting.html)

esslinger

conditional formatting

Is it possible to format one cell dependent on the value
of a different cell?

JE McGimpsey

conditional formatting

One way:

Select B1. Choose Format/Conditional Formatting...

CF1: Formula is =A110
Format1: Pattern/Red

will cause B1 to have a red background when A1 is 10.

In article ,
"esslinger" wrote:

Is it possible to format one cell dependent on the value
of a different cell?

All times are GMT +1. The time now is 01:08 PM.