May 21 2021 12:31 AM
Hi all
This is my first post and i'm not overly confident with excel, i can do the basic formulas etc.
I have a spreadsheet with up to 80 rows, in each row there are 12 cells (1 column for each month). In every month we have to enter the weight of residents. I need the cell for the current month to turn a colour (red) if it is more than the previous months figure in the cell to the left of it.
Please can anyone advise how i can do this. Many thanks
May 21 2021 01:05 AM
SolutionLet's say the first month is in column B, and the last in column M (with names in column A).
And let's say the data begin in row 2 (with headers in row 1).
Select C2:M80.
C2 should be the active cell in the selection.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first dropdown set to 'Cell Value'.
Select 'greater than' from the second dropdown.
Enter =B2 in the box next to it. B2 is the cell to the left of the top left cell of the selection.
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.
May 21 2021 01:47 AM
I need the cell for the current month...
May 21 2021 06:59 AM
Thank you but this does not appear to work. It could be that i'm doing something wrong but i don't think so.
Cells are all set to number format too.
May 21 2021 07:01 AM
May 21 2021 07:13 AM
I didn't write "select a formula to determine which cells to format" but "Use a formula to determine which cells to format", exactly what's in the Conditional Formatting New Rule dialog box (last option):
May 21 2021 07:37 AM
It appears that L.z. and I interpreted your question differently.
By "I need the cell for the current month to turn a colour (red) if it is more than the previous months figure in the cell to the left of it. ", do you meant that you only want to colour some cells in the column for May 2021? Or in the column for any mointh if its value is larger than that in the month before?
May 25 2021 04:49 AM
May 25 2021 05:07 AM
Try the steps in my first reply.
May 25 2021 05:16 AM
May 21 2021 01:05 AM
SolutionLet's say the first month is in column B, and the last in column M (with names in column A).
And let's say the data begin in row 2 (with headers in row 1).
Select C2:M80.
C2 should be the active cell in the selection.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first dropdown set to 'Cell Value'.
Select 'greater than' from the second dropdown.
Enter =B2 in the box next to it. B2 is the cell to the left of the top left cell of the selection.
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.