Hi,

Is there a way to format the cells in column B, based on the values of
Column A?

Thanks

Jaleel

Hi,

Yes there is and you would get better help had you indicated what the format
conditions might be but this may get you moving in the right direction.

Select the column B cells you want formatting which in the example start in
B1 and then

Format|Conditional format.
Select 'Formula is'
Enter the formula
=A16
Pick a colour and click OK

If a cell in column A is now 6 the corresponding cell in column B will be
coloured.

Mike

"Jaleel" wrote:

Hi,

Is there a way to format the cells in column B, based on the values of
Column A?

Thanks

Jaleel

formula is
=b1=2

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jaleel" wrote in message
...
Hi,

Is there a way to format the cells in column B, based on the values of
Column A?

Thanks

Jaleel

Mike,

Thank you very much. It worked even if the column A contains dates to
calculate number of days with =today().

Cheers!

Jaleel

"Mike H" wrote:

Hi,

Yes there is and you would get better help had you indicated what the format
conditions might be but this may get you moving in the right direction.

Select the column B cells you want formatting which in the example start in
B1 and then

Format|Conditional format.
Select 'Formula is'
Enter the formula
=A16
Pick a colour and click OK

If a cell in column A is now 6 the corresponding cell in column B will be
coloured.

Mike

"Jaleel" wrote:

Hi,

Is there a way to format the cells in column B, based on the values of
Column A?

Thanks

Jaleel