route217
asked on
Tricky Shapes formula part 4
Hi Experts Using Excel 2010
Need to amend the current formula in data range I6:BH10. So that the following happens
Row 9.
Date in E9 corresponds to milestone RAG in G9 i.e Amber - then F9 must correspond to H9 i.e Green..
Test-File_.xlsx
Need to amend the current formula in data range I6:BH10. So that the following happens
Row 9.
Date in E9 corresponds to milestone RAG in G9 i.e Amber - then F9 must correspond to H9 i.e Green..
Test-File_.xlsx
ASKER
The first date in e9 has a rag of amber the second date in f9 has a rag of green..but the CF in each cell shows amber if u look across row 9.
So you want the second diamond to display green?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Really not clear what you want the formula to do. You already have conditional formatting to colour the text.
Can you explain futher please?