Conditional Formatting

[Jaleel]

Hi,

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

Thanks

Jaleel

 

[Mike H]

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
=A1>6
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

 

[Don Guillett]

formula is
=b1=2

 

[Jaleel]

Mike,

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

Cheers!

Jaleel