MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
I'm sure i knew how to do this but i must be doing something wrong, basically i'm trying to make a tracking sheet where i want the cell in the end column to turn green (showing full completion)if the previous cells in the row have been set to green (showing completion of individual units).
So it laymans terms it's for eg IF C2 and D2 are green then turn K2 to green, also to complicate things further can i have an or function eg IF C2 or D2 are green then turn K2 to green
thanks
thanks
Are cells C2 and D2 turned green based on other values (eg conditional format) or are you manually changing their colour?
no, i'll just be changing them manually
Had a quick look and it seems like the only way to do that then is with a macro (eg VB code).
A better (easier) solution would be for cells C2 and D2 to just enter r,y or g (red, yellow, green) in the cell and have a conditional format set on the cell to change the colour to green.
Then for your K2 cell, you just have a formula that says if C2 and D2 are "g" then set K2 to "g" and use the same conditional format to change the colour of cell K2.
Whilst I'm not sure of the exact conditional formatting that you'll need to use, you certainly don't need both functions. If you use
IF C2 or D2 = green, then K2 = green
you don't need
IF C2 and D2 = green, then K2 = green
as there are no situations where the first function is false when the second one is true.
thanks clubber yeh that works, just to suss out the 'or' bits
ta
I'm sure you can do it better than I did - I figured you needed both to be green to make K2 green so it's and rather than or.
yeh, it's fine, now i'm up and running i'll suss it out,
ta
If you go with clubber's option of entering actual values and using conditional formatting to colour them (which seems more sensible than just colouring empty cells) you could use COUNTIF in K2 to check for the "g" in your range e.g. =COUNTIF(C2:D2,"g") then use conditional formatting to colour K2 green if >0
thanks, yeh i like that