Conditional formatting of Cells - dates and number

[crabsodyinblue]

Hi

I was wondering if in Excel , if it was possible to format cells depending on the value of another.

The problem is that for a publishing company that has magazines issued both by a date and also by a number depending on the title.

Here is an example

A B C
1 Title Issued by Issue Date/No.
2 Mag name 1 D 09/03/02
3 Mag name 2 N 243


The is two publication one is issued by date in format DD/MM/YY and one is issued by a numeric issue number.

The method by which the format the issue can be expressed can be found by using the indicator in cells B2 and B3 (i.e. D - issued by date , N - issued by number)

Ideally there would be a list of several publiactions , and to change the format of the cells in column C to be either in date format or numeric would take time. If possible is there a way to run a visual basic script to check the values in column B and apply the relevant cell formatting to the fields in column C


Thanks in advance

 

[dsb]

why do you need to do anything?

If the cell is in General-Numeric format when you start,
entering a number will display as a number
entering a date will change the format to a date

If you foresee altering the state of a cell later, then you might want to have a routine that corrects the format.

dsb