ExcelBanter - Conditional Formating

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formating (https://www.excelbanter.com/excel-discussion-misc-queries/75539-conditional-formating.html)

tricia

Conditional Formating

Can I change the format of one cell based on the value of another?

Gary''s Student

Conditional Formating

Yes:

Say you have text in B1 and a number in A1. You want the value of A1 to
decide the format of B1. Select B1 and pull-down conditional formating.
Pick Formula is

use:

=(A10) and select a format. if A1 is positive you will see your format.
--
Gary's Student

"tricia" wrote:

Can I change the format of one cell based on the value of another?

All times are GMT +1. The time now is 04:32 AM.