Excel help

[craigjm]

I need to create a spreadsheet that has drop downs for RAG status in the form of a coloured cell and the letter R, A or G. I know how to do this for standard drop downs of data but how do you also colour the cell?

In addition I then need to also show these coloured cells on another sheet in the book in a kind of dashboard style. How do i reference the appropriate cells to show in the dashboard and based on the above will the colours also move across?

Thanks

[JulietRomeo]

Hi look up conditional formatting...rags pretty simple to colour.

On the linked sheet reference the ragged cell , worst case apply more conditioninal formatting if it doesn’t come across...
Ping me directly if any questions or u want a dummy example file

[craigjm]

Ok thanks I’ll try that

How do you reference a cell from another sheet?

[BigTZ4M]

To reference another sheet you put the name of the sheet and then put an exclamation mark.

So if you want to reference cell A1 on a worksheet called Sales you'd put =Sales!A1

If the worksheet name has a space in it then you encase the sheet name in a single quote. e.g. if the sheet was called Sales Results then you'd reference ='Sales Results'!A1

If you're editing a formula you can just change sheet and click on the cell to auto-populate the above.

Edited by BigTZ4M on Monday 12th August 09:28

Edited by BigTZ4M on Monday 12th August 09:28

[craigjm]

Thanks BigTZ4m I’ll have a go and report back

[hyphen]

Should have a go at learning to use Google and report back on that too...

As you could have found out how to reference another sheet in seconds.

Teach a man to fish...

[paulrockliffe]

For your second sheet, format the first as a Table then point a Pivto Table at that table and draw the table you want. It sounds like you want to filter your main table to a particular status, so I would add RAG to the Pivot as a Slicer and filter away. But it's not really clear what you're aiming for, so that might miss the mark.

[craigjm]

hyphen said:

Should have a go at learning to use Google and report back on that too...

As you could have found out how to reference another sheet in seconds.

Teach a man to fish...

Yes very helpful