Adding the cell contents to another cell only by changing colour of cell

**Chris856** · 11-17-2021, 12:31 PM

Hi i am very new to all this and i have created a rosta for my work team on excel. i have the shifts in a cell and the hours that the shift is. i want to be able to colour the hours cell to so the colour allocated to holiday or course etc. i then want the hours number to be deducted from the holiday total (in another cell) for that particular employee

hope that makes sense.

Regards
Chris

**WideBoyDixon** · 11-17-2021, 03:17 PM

Hi Chris,

A formula can't "see" the colour of the cell so it's not possible to do what you want to do using Excel formulas. The only was would be to use VBA and that may be overkill for your requirements. If you can attach a sample with any sensitive data removed, someone can take a look and perhaps suggest an alternative solution.

WBD

Adding the cell contents to another cell only by changing colour of cell

LinkBack

Thread Tools

Rate This Thread

Display

Adding the cell contents to another cell only by changing colour of cell

Re: Adding the cell contents to another cell only by changing colour of cell

Thread Information

Users Browsing this Thread

Similar Threads

Changing cell colour based on another cell's value, but the latter cell changes

[SOLVED] Changing text colour in a cell based on value or colour of another cell.

[SOLVED] Changing Font Colour based on cell contents

Look up a value from a table, adding the text and changing the cell background colour

Change cell colour based on contents of adjacent cell

Deleting contents of a cell based on colour of the cell

[SOLVED] Changing Background Colour Based on Cell Contents

Bookmarks

Bookmarks

Posting Permissions