cheking through data and show status

[sanlen]

Hi All,

I am trying to show the status of my project as below:

- if C is number then the color in my Status sheet should be Orange
- if C is blank then color in my status sheet should be White
- if any of C to V contain the word HALTED then the color in my status sheet should be Red
- if V is date then color in my status sheet should be blue

i have attached a reference file.

Your comment will be very much appreciated.

Thanks,
sanlen

[Marcol]

To use conditional formatting where Sheet "Status" refers to Sheet "Detail" you will need to create a named range
Name:= DetailTable
Refers To:

Please Login or Register  to view this content.

This is dynamic, your detaill sheet can grow and the formula will adjust to suit, don't leave blanks in Column A "Name"
N.B.
This formula refers to 23 columns, (up to Column W), in Sheet "Detail" this extra column is a helper that simplifies the C/F formula Condition 1

In Sheet "Detail" Column W. Rw 6 (Helper Column.)

Please Login or Register  to view this content.

Drag/Fill Down

With Sheet "Status" conditional formatting
Condition 1 (Red)
Formula is:

Please Login or Register  to view this content.

Condition 2 (Blue)
Formula is:

Please Login or Register  to view this content.

Condition 3 (Orange)
Formula is:

Please Login or Register  to view this content.

All apply to =$A:$A

Hope this helps.

[sanlen]

Hi,

Thanks you very much for your help. I actually want to show the word "red", "blue", "white",......as i need to use these word for other purpose. My appologize for this as i should mention this in my previouse post.

I added another column "Status" in the status sheet.

Your further advise will be very much appreciated.

Thanks,
sanlen

[Marcol]

Have a look at this workbook.

Sheet "Status (1)" is based on the initial solution for conditional formatting, and therefore a named range. This sheet needs the helper column in Sheet "Detail" Column W.

Sheet "Status (2)" is probably better.
Column "Status", effectively becomes the helper column for the conditional formatting.
This doesn't require the named range and Sheet "Detail" Column W.

Compare the two sheets, before deciding which suits you best.